Logs

Table of contents
  1. 1. Using Logs

All backup, recovery, reporting and scheduling operations statuses are logged by ZRM for MySQL.

These logs are available under /var/log/mysql-zrm directory on the local machine where ZRM for MySQL runs.

Use the logs for debugging in case of failures as well as for auditing backup/recovery database operations.

If detailed logs for a backup run is required the following parameter can be specified either in the configuration files.

verbose=1
UtilitiesLog file name
mysql-zrm, Pre-Backup Plugin, Post-Backup Plugin, Binary Log Parser Plugin, Copy Pluginmysql-zrm.log
mysql-zrm-reportermysql-zrm-reporter.log
mysql-zrm-schedulermysql-zrm-scheduler.log
Pre Scheduler Pluginmysql-zrm-pre-scheduler.log

Consult the plugins section for more details on plugins.

Using Logs

Example: mysql-zrm log file entries from a restore of incremental backup:

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

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

Action being performed is listed next.

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

Comment: Command line parameters of mysql-zrm are listed next.

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: }

Comment: Parameters used for restore operation are listed next.

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

Comment: Validation of backup parameters are listed next.

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

Comment: 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.

Comment: MySQL server is shutdown after database restoration.