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


Related articles: