MySQL :: Security in MySQL :: 5.3.3 MySQL Backup Status Reporting and Monitoring

Additional languages

Security in MySQL :: 5 Backup and Recovery :: 5.3 Using MySQL Backup :: 5.3.3 MySQL Backup Status Reporting and Monitoring

Section Navigation [Toggle]

MySQL provides information about the status or progress of BACKUP DATABASE or RESTORE operations in the following ways:

SHOW PROCESSLIST displays information while a thread performing a backup or restore is executing.
Upon successful completion, the BACKUP DATABASE and RESTORE statements return a result set with the backup number. (This number is the ID for the corresponding row or rows in the metadata tables described later.) Warnings produced during the operation can be displayed with SHOW WARNINGS.

If errors occur during a backup or restore operation, they are written to the error log, recorded in the progress tables, and are available via the SHOW ERRORS and SHOW WARNINGS statements.

If a fatal error occurs, the BACKUP DATABASE or RESTORE statement reports it to the user.
The server maintains backup_history and backup_progress tables in the mysql database that contain metadata indicating backup status and progress. It is also possible to write log information to files. For information about selecting log destinations, see Section 5.3.3.1, “MySQL Backup Log Control”. For a description of what is logged, see Section 5.3.3.2, “MySQL Backup Log Contents”.

If you upgrade to MySQL 6.0.5 or later from an older version, be sure to run mysql_upgrade to ensure that the backup log tables exist. From MySQL 6.0.5 through 6.0.7, these tables were named online_backup and online_backup_progress.

Currently, there are no INFORMATION_SCHEMA tables corresponding to the backup_history and backup_progress tables.