Pre-defined Reports
The mysql-zrm-reporter utility generates predefined backup reports with --show option. The reports are listed below.
Backup report name | Description | Information available |
---|---|---|
backup-status-info | Status of backup runs | backup-set, backup-date, backup-level, backup-status, backup-comment |
backup-method-info | Backup methods used | backup-set, raw-databases, raw-databases, logical-databases |
backup-retention-info | How long are the backups retained? | backup-set, backup-date, backup-level, backup-size, retention-policy |
backup-performance-info | Backup performance | backup-set, backup-date, backup-level, backup-size, backup-size-compressed, backup-time,compress-encrypt-time |
backup-app-performance-info | Impact of backups on application | backup-set, backup-date, backup-level, backup-size, backup-time, read-locks-time, flush-logs-time |
restore-info | Information for doing full/incremental recovery of databases | backup-set, backup-date, backup-level, backup-directory, backup-status, backup-comment |
selective-restore-info | Information for doing selective recovery of databases | backup-set, backup-date, incremental |
replication-info | Replication files backed up | backup-set, backup-date, replication, slave-load-files |
Specific backup runs can be selected from the predefined backup reports using --where option.
Example: A backup status report
# mysql-zrm-reporter --where backup-set=backupSet1 --show backup-status-info backup_set backup_date backup_level backup_status comment ------------------------------------------------------------------------------------------- backupSet1 20060909100021 0 Backup Before application upgrade succeeded backupSet1 20060909100123 0 Backup After application upgrade succeeded backupSet1 20060909100300 0 Backup Nightly succeeded