How to Back Up and Restore MySQL Databases
Use mysqldump to create logical backups of your MySQL databases and restore them when needed.
1. Back up a single database
mysqldump -u myuser -p myapp > myapp_backup.sql2. Back up all databases
mysqldump -u root -p --all-databases > all_databases.sql3. Restore a database
mysql -u myuser -p myapp < myapp_backup.sql4. Schedule daily backups with cron
0 2 * * * mysqldump -u myuser -pYOURPASS myapp > /backups/myapp_$(date +\%F).sqlKeep backups off-server and test a restore periodically so you know it works.
