Mysql-zrm-parse-binlogs

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

NAME

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

SYNOPSIS

mysql-zrm-parse-binlogs
                      [--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]
                      [--quiet|--no-quiet]
                      [--verbose]
                      [--help]


DESCRIPTION

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.

OPTIONS

--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.
--quiet|--no-quiet
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.
--verbose
Provide more detailed output in the log. Verbose output is turned off by default.
--help
Displays the help message and exits. This command-line-only parameter cannot be specified in the configuration file.

EXAMPLES

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.

FILES

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

RETURN VALUES

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

SEE ALSO

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

AUTHOR

Zmanda Inc. (http:/www.zmanda.com/)