Backup and Restore a Database - Backups

Question 1

Backup and Restore a Database - Backups

Answer 1

mysql -u root -p

SHOW DATABASES;

mkdir /backup
cd /backup
mysqldump -u root -p emails > emails.sql

When backing up multiple databases:
mysqldump -u root -p –databases emails mysql > emails_mysql.sql