Remove my-sql bin | PURGE BINARY LOGS | old files

The purpose of MY SQL Binary files is to data recovery. For big database my sql binary files eat lot of disk space so If you have backed up your data and want to remove my-sql binary log files follow the procedure.

Go to path my sql installed directory. I have installed wamp server in default directory


mysql5.5.16 it could be different according to you my-sql version.

Copy name of last created log file in my cause it’s name is mysql-bin.000085 (sort folders by date fodified)

There extention should be different.

Run following query in sql

PURGE BINARY LOGS TO 'mysql-bin.000085';




Leave a comment

Your email address will not be published. Required fields are marked *