From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)

Jump to: navigation, search



mysql-zrm-parse-binlogs - Utility to parse MySQL binary logs for ZRM for MySQL


                      [--source-directory dir_name]
                      [--bin-logs "/fullpath/name1 /fullpath/name2 ..."]
                      [--mysql-binpath MySQL_command_location]
                      [--parse-binlogs-plugin plugin]
                      [--parse-binlogs-plugin-options "opt1 opt2 ..."]
                      [--options-file filename]
                      [--tmpdir temporary directory to be used]


Parse binary logs to find out the timestamp and/or log position of specific database events.

This utility will display the parsed output of the binary logs. This is useful to find out the log positions and/or timestamp to be used for restore operations. Either the source-directory or the bin-logs option should be specified. When the source-directory option is specified then the parsed output of the binary logs from that backup will be displayed. When bin-logs option is specified then parsed output of the binary log file specified will be displayed.


--backup-set name 
Specify backup-set for the backup run. The default value is BackupSet1.
--source-directory directory name 
Choose the directory containing a backup. Both source-directory and bin-logs options should not be specified. If both are present, the utility will throw an error.
--bin-logs "/fullpath/name1 /fullpath/name2 ... 
List binary log files, along with their full paths to be used for restore. Both source-directory and bin-logs options should not be specified. The utility will throw an error if both are specified
--parse-binlogs-plugin plugin 
Set the plugin along with full pathname that filters the output of parse-binlogs action. This plugin is optional.
--parse-binlogs-plugin-options "option1 option2 ..." 
Pass options to the parse-binlogs-plugin as one of the command line arguments.
--options-file filename 
Set the file along with full pathname that contains MySQL command options.
--mysql-binpath MySQL_command_location 
Set the full path where the MySQL binaries are installed. For example: /opt/lampp/bin
--tmpdir temp_directory 
Full path of the directory for storing temporary files and directories on the backup host. The default is to use the system-specified temporary directory on the backup host, e.g. /tmp.
Choose quiet to suppress display of log messages on stdout. Choose no-quiet to display the log messages to stdout. The default is --no-quiet.
Provide more detailed output in the log. Verbose output is turned off by default.
Displays the help message and exits. This command-line-only parameter cannot be specified in the configuration file.


mysql-zrm --action  parse-binlogs  --bin-logs  /var/lib/mysql-zrm/backupset1/20060818121532/mysql-bin.[0-9]* /var/lib/mysql-zrm/backupset1/20060819121532/mysql-bin.[0-9]*

The above command parses and displays the relevant contents of all specified binary log files. Use it to find out what position and or timestamp to specify for selective restores.


Directory under which all backup data is stored.
/etc/mysql-zrm/backup set name/mysql-zrm.conf 
Configuration file read by ZRM for MySQL.


On success, zero is returned. On error, non-zero value is returned.


mysql-zrm(1), mysql-zrm-backup(1), mysql-zrm-manage-backup(1), mysql-zrm-restore(1), mysql-zrm-check(1), mysql-zrm-getconf(1), mysql-zrm-list(1), mysql-zrm-parse-binlogs(1), mysql-zrm-purge(1), mysql-zrm-extract-backup(1), mysql-zrm-verify-backup(1), mysql-zrm-scheduler(1), mysql-zrm-reporter(1), mysql-zrm.conf(5), mysqldump(1), mysqlbinlog(1), mysql(1), lvm(8).


Zmanda Inc. (http:/

Personal tools