Cleaning Mysql Binary Log Files
by rajesh[ Edit ] 2009-10-31 14:29:10
Mysql binary log files will be named like -bin.000001,-bin.000002 and can be found under /usr/local/var/ [on default installations]
We can delete the log files by using the query "Reset master"
reset master;
Once you execute the query it will delete all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file.
But I am not sure about any other drawbacks in running this query, so read a bit more before running this query.