Backups failed. What do I do?

MySQL ZRM logs are available under /var/log/mysql-zrm directory on the machine where MySQL ZRM is running. All backup and recovery operations, status of these operations are logged. These logs can be used for debugging in case of failures as well as auditing backup/recovery database operations.

For more information on plugins, please see Custom plugins section.

Example: mysql-zrm log file entries from a succesful restore of incremental backup. This annotation of log file shows how to read the log files.

Wed Aug 30 02:39:48 2006: INFO: mysql-zrm started

All the MySQL backup runs starts with "mysql-zrm started" message.

Wed Aug 30 02:39:48 2006: INFO: action being performed is restore
Wed Aug 30 02:39:48 2006: INFO: backup set being used is backup

Above lines show the list of command line parameters to mysql-zrm

Wed Aug 30 02:39:48 2006: INFO: Reading options from file /etc/mysql-zrm/backup/mysql-zrm.conf
Wed Aug 30 02:39:48 2006: INFO: Mail address: root is ok
Wed Aug 30 02:39:48 2006: INFO: Input Parameters Used {
Wed Aug 30 02:39:48 2006: INFO:         verbose=1
Wed Aug 30 02:39:48 2006: INFO:         backup-level=1
Wed Aug 30 02:39:48 2006: INFO:         mailto=root
Wed Aug 30 02:39:48 2006: INFO:         destination=/mysql-zrm
Wed Aug 30 02:39:48 2006: INFO:         databases=wikidb
Wed Aug 30 02:39:48 2006: INFO:         source-directory=/mysql-zrm/backup/20060830020843
Wed Aug 30 02:39:48 2006: INFO:         host=localhost
Wed Aug 30 02:39:48 2006: INFO:         database=wikidb
Wed Aug 30 02:39:48 2006: INFO:         backup-mode=raw
Wed Aug 30 02:39:48 2006: INFO:         password=******
Wed Aug 30 02:39:48 2006: INFO:         user=root
Wed Aug 30 02:39:48 2006: INFO:         stop-position=5003
Wed Aug 30 02:39:48 2006: INFO: }

The above lines show the list of parameters used for restore operation

Wed Aug 30 02:39:48 2006: INFO: Getting the data directory
Wed Aug 30 02:39:48 2006: INFO: mysqladmin --user=root --password=***** --host=localhost variables
2> /tmp/mysql-zrm-20060830023948.out
Wed Aug 30 02:39:48 2006: INFO: datadir is /var/lib/mysql/
Wed Aug 30 02:39:48 2006: INFO: mysql_version is 4.1.21-standard-log
Wed Aug 30 02:39:48 2006: INFO: Checking if this is a replication slave using command
Wed Aug 30 02:39:48 2006: INFO: echo "show slave status"|mysql --user=root --password=***** --host=localhost
Wed Aug 30 02:39:48 2006: INFO: This is not a replication slave or we do not have appropriate access rights.
 replication data if any has not been backed up.
Wed Aug 30 02:39:48 2006: INFO:  Ignoring the --replication option

The above lines show validation of backup parameters

Wed Aug 30 02:39:48 2006: INFO: Restoring incremental
Wed Aug 30 02:39:48 2006: INFO: mysqlbinlog --user=root --password=***** --host=localhost --stop-position=5003 
--database=wikidb "/mysql-zrm/backup/20060830020843"/vmsql4-bin.[0-9]* | mysql --user=root --password=***** 
--host=localhost
Wed Aug 30 02:39:48 2006: INFO: Incremental restore done

Incremental restoration is complete

Wed Aug 30 02:39:48 2006: INFO:  for database wikidb
Wed Aug 30 02:39:48 2006: INFO:
Wed Aug 30 02:39:48 2006: INFO: Shutting down MySQL
Wed Aug 30 02:39:53 2006: INFO: Restore done in 5 seconds.

MySQL server is shutdown after database restoration.