SingleStore DB

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;.

Note: 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.