Backup and Restore a Database - Backups Flashcards Preview

RHCE > Backup and Restore a Database - Backups > Flashcards

Flashcards in Backup and Restore a Database - Backups Deck (1):
1

Backup and Restore a Database - Backups

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