mysql.backup_history table has been updated
with the release of MySQL Enterprise Backup 8.0.12 in the following ways:
Changed the storage engine from CSV to InnoDB
Added a new column for server UUIDs
When MySQL Enterprise Backup 8.0.12 tries to perform its first full backup on a database, it attempts to perform a format update on the table automatically with the following steps:
Create in the new format a table named
mysql.backup_history_newand copy into it data from the original
Rename the original
mysql.backup_history_old, and the
For the migration to the new table format to succeed, before
performing the first backup task with MySQL Enterprise Backup 8.0.12
, grant the required privileges to the
mysqlbackup user on the server by issuing these
statements at the mysql client: :
GRANT CREATE, INSERT, DROP ON mysql.backup_history_old TO 'mysqlbackup'@'localhost'; GRANT CREATE, INSERT, DROP, ALTER ON mysql.backup_history_new TO 'mysqlbackup'@'localhost';
If these privileges are not granted, the first full backup on the upgraded server will fail with an error message similar to the following:
180612 08:40:45 MAIN ERROR: MySQL query 'DROP TABLE IF EXISTS mysql.backup_history_old': 1142, DROP command denied to user 'mysqlbackup'@'localhost' for table 'backup_history_old' mysqlbackup failed with errors!
These privileges are no longer needed after the first full backup has been performed by MySQL Enterprise Backup 8.0.12 , by which point they can be revoked.
If you are working with a multiprimary Group Replication setting, make sure these privileges are granted on all primary nodes; see also Chapter 8, Using MySQL Enterprise Backup with Group Replication.