MySQL Purge Binary Logs: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 8: | Line 8: | ||
## <tt>'''mysql> purge binary logs before 'yyyy-mm-dd hh:mm:ss''''</tt> (note: the seconds is optional) | ## <tt>'''mysql> purge binary logs before 'yyyy-mm-dd hh:mm:ss''''</tt> (note: the seconds is optional) | ||
== Further Reading == | |||
# [http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html MySQL Reference Guide - PURGE BINARY LOGS Syntax] | |||
[[Category:MySQL]] | [[Category:MySQL]] |
Revision as of 11:53, 26 July 2012
- Change to the directory containing the binary log files.
- Note the last time on the first to newest mysql-bin.######, use that time for the purge binary logs before command.
- Flush the logs.
- # mysqladmin flush-logs -p -uroot
- Login to MySQL.
- mysql -p -uroot
- Purge the binary logs.
- mysql> purge binary logs before 'yyyy-mm-dd hh:mm:ss' (note: the seconds is optional)