Backing Up and Restoring MySQL Databases
A backup you've never restored is a hope, not a backup. Here's how to take consistent MySQL backups and prove they work. Logical backups with mysqldump mysqldump --single-transaction --routines --triggers --events \ --set-gtid-purged=OFF -h db -u backup -p sho...