Clearing Backup History

You can remove all the entries in the MV_BACKUP_HISTORY table in the information_schema database by running CLEAR BACKUP_HISTORY;.

information_schema.MV_BACKUP_HISTORY is populated only when the BACKUP DATABASE command is run to create a database backup.

Selectively Delete Rows from information_schema.MV_BACKUP_HISTORY

To clean up individual rows specific to a particular backup use:

CLEAR BACKUP_HISTORY backup_id = <id>;

or

CLEAR BACKUP_HISTORY <success/failure>;

Success/failure are listed in the STATUS column of the MV_BACKUP_HISTORY table.

Last modified: May 5, 2023

Was this article helpful?