Mysql-zrm-reporter

NAME

mysql-zrm-reporter - MySQL backup reporting tool.

SYNOPSIS

mysql-zrm-reporter --fields <name1,name2,name3 ....>
                   [--directory <dir> ] 
                   [--key <name=value>]
                   [--help]

DESCRIPTION

This tool is part of Zmanda Recovery Manager for MySQL (MySQL ZRM). This tool can be used to display various information regarding MySQL database backups created using mysql-zrm(1) tool.

BACKUP INFORMATION

The list of information available for each backup run:

backup-set

Name of the Backup Set

backup-date

Date and time stamp of Backup

mysql-version

MySQL server version

backup-directory

The location of backup directory

backup-level

Backup level (full or incremental)

raw-databases

List of databases that have raw backups

backup-time

Time taken to do the backup

backup-size

Size of backup

next-binlog

Next binary log file name

last-backup

Location of the last backup for this backup set

backup-status

Status of the backup run. The values can be "Backup Failed", "Backup done with errors", "Backup succeeded".

raw-tables(snapshot)

List of tables backed up using LVM snapshots

raw-tables

List of tables backed up using mysqlhotcopy

logical-databases

List of databases backed up using mysqldump(1)

logical-tables

List of tables belonging to "logical-databases" backed up using mysqldump(1)

replication

Names of replication files that were backed up

slave-load-files

Names of SQL_LOAD* files that were backed up

OPTIONS

--directory <dir>

Specify the backup root directory, default value is /var/lib/mysql-zrm

--fields <name1,name2,name3...>

Specify list of backup parameters to display. List of field names are described in BACKUP INFORMATION section.

--key <name=value>

The tool will display the MySQL backup parameters where the key matches value.

--help

Display help message and exit.

EXAMPLES

Following command displays backup date, location of backups, backup set name:

# mysql-zrm-reporter --directory /var/lib/mysql-zrm/backup --fields backup-date,backup-directory,backup-set

Following command displays size of backup, backup set name, and date of backup:

# mysql-zrm-reporter --directory /var/lib/mysql-zrm/backup --fields backup-date,backup-set,backup-size

Following command searches all index files for "config1" backup-set name and displays size of backup, backup set name and date of backup

# mysql-zrm-reporter --directory /var/lib/mysql-zrm/backup --fields backup-date,backup-set,backup-size \
  --key backup-set=config1

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 mysql-zrm tool.

RETURN VALUES

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

SEE ALSO

mysql-zrm(1), mysql-zrm-scheduler(1), mysql(1)

AUTHOR

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