Kevin Warrington

Loading clever subtitle...

Deleting MySQL Bin Files

To view your current bin files:

$ mysql -u root -p
mysql> SHOW MASTER LOGS;

To clear all logs but the last one:

mysql> PURGE MASTER LOGS TO 'mysql-bin.000107';

Open my.cnf and comment out the following lines to prevent logging in the future:

# log-bin=mysql-bin

Restart your server and confirm logging is now disabled:

$ mysql.server restart
$ mysql -u root -p
mysql> SHOW MASTER LOGS;

Comments