MySQL Enterprise Backup 9.5 User's Guide  / Appendixes  /  Backup Progress Table Update

Appendix F Backup Progress Table Update

Themysql.backup_progress table has been updated with the release of MySQL Enterprise Backup 8.0.19 in the following ways:

  • Changed the storage engine from CSV to InnoDB

  • Added a new auto-increment primary key columnid

  • Added a composite index on thebackup_id andcurrent_timestamp columns

When MySQL Enterprise Backup 9.5 tries to perform its first full backup on a database server, it automatically checks the format of themysql.backup_progress table. If it detects that the table is in the old format (which means the server has been upgraded from 8.0.18 or earlier and has been backed up by MySQL Enterprise Backup before), it attempts to perform a format update on the table automatically with the following steps:

  1. Create in the new format a table namedmysql.backup_progress_new and copy into it data from the originalmysql.backup_progress table.

  2. Rename the originalmysql.backup_progress table tomysql.backup_progress_old, and themysql.backup_progress_new table tomysql.backup_progress.

  3. Drop themysql.backup_progress_old table.

For the migration to the new table format to succeed, before performing the first backup task with MySQL Enterprise Backup 9.5 for the first time on a MySQL Server that has been upgraded from 8.0.18 or earlier and has been backed up by MySQL Enterprise Backup before, grant the required privileges to themysqlbackup user on the server by issuing these statements at themysql client: :

GRANT ALTER ON mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP ON mysql.backup_progress_old TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, ALTER ON mysql.backup_progress_new TO 'mysqlbackup'@'localhost';

If these privileges are not granted, the table upgrade will fail with an error message similar to the following:

191219 20:48:43 MAIN   ERROR: MySQL query 'RENAME table mysql.backup_progress TO mysql.backup_progress_old, mysql.backup_progress_new TO mysql.backup_progress': 1142, ALTER command denied to user 'mysqlbackup'@'localhost' for table 'backup_progress'

These privileges are no longer needed after the first full backup has been performed by MySQL Enterprise Backup 9.5, by which point they can be revoked.

Note

If you are working with a multiprimary Group Replication setting, make sure these privileges are granted on all primary nodes; see alsoChapter 9,Using MySQL Enterprise Backup with Group Replication.