Backing up and restoring MySQL databases using Mysqldump

Linux vps is the most convenient and can be used under ssh.

1. Back up the MySQL database

1. Back up a single database
mysqldump -u root -pmypassword wp > wpbak.sql
root is the mysql database user name, mypassword is the password, wp is the database name, and wpbak.sql is the backup file.

2. Back up multiple databases
mysqldump -u root -pmypassword –databases wp stuff > wpbak.sql
root is the mysql database user name, mypassword is the password, wp and stuff are the database names, and wpbak.sql is the backup file.

3. Back up all databases
mysqldump -u root -pmypassword –all-databases > all-databases.sql
root is the mysql database user name, mypassword is the password, and all-databases.sql is the backup file.

2. Restore MySQL database

Login to database
mysql -u root -pmypassword
root is the mysql database user name, mypassword is the password

1. Restore a single database
mysql -u root -pmypassword [database_name] < dumpfilename.sql
root is the mysql database user name, mypassword is the password, [database_name] is the database name, and dumpfilename.sql is the restored data

2. Restore multiple databases
mysql -u root -p mypassword < all-databases.sql
root is the mysql database user name, mypassword is the password, and all-databases.sql is the restored data