PURGE BACKUP LOGS [ TOid
| BEFOREdatetime_expr
]
The PURGE BACKUP LOGS
statement
removes rows from the backup_history
and
backup_progress
MySQL Backup log tables in the
mysql
database (see
Section 1.7, “MySQL Backup Status Logging and Monitoring”). This statement requires
the SUPER
privilege.
With no TO
or BEFORE
clause,
the statement deletes all rows in the log tables. With a
TO
clause, the statement deletes rows with a
backup_id
column value less than the
id
value. With a
BEFORE
clause, the statement deletes rows with
a start_time
column value less than the
datetime_expr
value. The
datetime_expr
argument should evaluate
to a DATETIME
value (a value in
'YYYY-MM-DD hh:mm:ss'
format).
Examples:
PURGE BACKUP LOGS TO 143; PURGE BACKUP LOGS BEFORE '2009-08-31 14:32:19';