Differences between version 2 and predecessor to the previous major change of MySQLNotes.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 2 | Last edited on Wednesday, February 25, 2004 12:00:03 am | by MattBrown | Revert |
| Older page: | version 1 | Last edited on Tuesday, September 2, 2003 2:55:19 am | by AristotlePagaltzis | Revert |
@@ -29,4 +29,9 @@
! Done.
You should now be able to connect using the new password. You can now stop mysqld and restart it normally.
+
+!!! Clearing Unwanted Binary Log Files
+mysql in some configurations can log all database activity to a binary log file (usually in /var/lib/mysql). If you have a busy site this can grow quite large. The recommended management solution in the mysql manual is to remove binary log files that you no longer want. They suggest removing files that are older than 3 days. To remove all binary log files you can use the following command
+
+ RESET MASTER;
