Cleaning Mysql Binary Log Files

by rajesh 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.

Tagged in:

1718
like
0
dislike
0
mail
flag

You must LOGIN to add comments