General Information

Backing up and restoring a database.

Backup 1 specific database: Run the MySQL Dump utility to backup tables within a database

mysqldump -u root -p emails > /backup/emails_backup.sql

• Builds SQL commands that will create the tables from scratch

Backup multiple databases

mysqldump -u root -p --databases emails mysql > /backup/emails_mysql_backup.sql

• –databases → flag to backup multiple databases at once

Backup all databases

mysqldump -u root -p --all-databases > /backup/all_dbs.sql