|
|
Cleaning Mysql Binary Log Files - Mysql
|
Views : 719
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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.
|
|
By rajesh, On - 2009-10-31 |
|
|
|
