Backup All Databases To A File

Jason M Potter answered on October 15, 2022 Popularity 9/10 Helpfulness 9/10

answer Backup All Databases To A File

Backup All Databases To A File

Comments(1)

# A single file backup of all databases named all-databases-backup.sql
# Note: reads ~/.my.cnf for client data: username, password, hostname, port, etc
mysqldump --all-databases > all-databases-backup.sql
# Example without reading ~/.my.cnf
mysqldump -h hostname -u username -p --all-databases > all-databases-backup.sql

Popularity 9/10 Helpfulness 9/10 Language shell

Source: www.liquidweb.com

Tags: backup file mysql-backup mysqldump shell

Link to this answer
Share Copy Link

Contributed on Oct 15 2022

Jason M Potter

0 Answers Avg Quality 2/10

Backup All Databases To A File

Contents

More Related Answers

Backup All Databases To A File

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.