Skip navigation links
MySQL Backup Reference Manual :: 1 Using MySQL Backup :: 1.7 MySQL Backup Status Logging and Monitoring
1.7.1 MySQL Backup Log Control »
Section Navigation      [Toggle]

1.7. MySQL Backup Status Logging and Monitoring

[+/-]

1.7.1. MySQL Backup Log Control
1.7.2. MySQL Backup Log Contents

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 log backup information to files. For information about selecting log destinations, see Section 1.7.1, “MySQL Backup Log Control”. For a description of what is logged, see Section 1.7.2, “MySQL Backup Log Contents”.

    If you upgrade to a version of MySQL that includes MySQL Backup from a version that does not, be sure to run mysql_upgrade to ensure that the backup log tables exist.

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