Recovery
From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to searchRecover MySQL database
Recovery of backups is done in two steps:
Step 1
Identify the backup image to be recovered by running a backup report ( restore-full-info ) that lists all backup images that are available:
# /usr/bin/mysql-zrm-reporter -show restore-info --where backup-set=dailyrun backup_set backup_date backup_level backup_directory ------------------------------------------------------------------------------------------- dailyrun Sun 10 Sep 2006 0 /var/lib/mysql-zrm/dailyrun/ 02:15:23 AM PDT 20060910021523 dailyrun Sun 17 Aug 2006 0 /var/lib/mysql-zrm/dailyrun/ 02:16:43 AM PDT 20060917021643
Step 2
Use mysql-zrm utility to recover the database from the full backup image.
# mysql-zrm --action restore --backup-set dailyrun \ --source-directory /var/lib/mysql-zrm/dailyrun/20060917021643 MySQL server has been shutdown. Please restart after verification.
After restoring the database or tables in the database, it is important to verify the restored database contents before restarting the MySQL server.