Clearing Backup History
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
You can remove all the entries in the MV_
table in the information_
database by running CLEAR BACKUP_
.
information_
is populated only when the BACKUP DATABASE
command is run to create a database backup.
Selectively Delete Rows from information_
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_
table.
Last modified: May 5, 2023