Categories
MySQL

PURGE MASTER LOGS

PURGE MASTER LOGS TO ‘mydb-bin.0023’;

Then the binlog before ‘mydb-bin.0023’ will be deleted.

You may also do this:

PURGE MASTER LOGS BEFORE ‘2008-06-13 08:00:00’;