First, use
`
SHOW BINARY LOGS;
SHOW MASTER LOGS;
`
to find the binlog name, then use the magic quote as below

Here is the magic

purge binary logs to 'mysql-bin.****';

* is the name of latest binary log file.

This is safe and quick, and can get more free space.

Tag:mysql, binary log

Add a new comment.