mysql manually removes the BINLOG method
- 2020-05-15 02:24:18
- OfStack
Execute the following command in MySQL:
PURGE {MASTER | BINARY} LOGS TO ' log_name'
PURGE {MASTER | BINARY} LOGS BEFORE ' date'
PURGE {MASTER|BINARY} LOGS BEFORE DATE_SUB(NOW(),INTERVAL 7 DAY);
Such as:
mysql>PURGE MASTER LOGS TO ' mysql-bin.010 ' ;
mysql>PURGE MASTER LOGS BEFORE ' 2008-06-22 13:00:00 ' ;
mysql>PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 7 DAY);