Pre-defined Reports
From The Open Source Backup Wiki (Amanda, MySQL Backup)
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
