Recovery

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search

Recover 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.