Complete Restoration of Full & Incremental Backups

Data can be restored from full backups as well as incremental backups with the mysql-zrm utility.

ZRM for MySQL does not support restoring to live databases. All applications using the database that is being restored must be stopped.

mysql-zrm can be used to restore full/incremental backups using restore action.

Example: Complete restoration of backup set backupSet1 :

# mysql-zrm --action restore --backup-set backupSet1 \
  --source-directory /var/lib/mysql-zrm/backupSet1/20060829140710
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.