When using MySQL with log files, you will from time to time want to remove/backup old log files and tell MySQL to start logging on new files. 9.2 The update log.
One a Linux (
On other systems you must install a short script yourself that you
You can force MySQL to start using new log files by using
The above command does the following:
If you are using only an update log, you only have to flush the logs and then move away the old update log files to a backup. If you are using the normal logging, you can do something like:
shell> cd mysql-data-directory shell> mv mysql.log mysql.old shell> mysqladmin flush-tables
and then take a backup and remove `mysql.old'.