If you flush the logs using
FLUSH LOGS, or
mysqladmin flush-logs, the server closes and
reopens any error log file to which it is writing. To rename an
error log file, do so manually before flushing. Flushing the
logs then opens a new file with the original file name. For
example, assuming a log file name of
to rename the file and create a new one, use the following
mv host_name.err host_name.err-old mysqladmin flush-logs mv host_name.err-old backup-directory
On Windows, use rename rather than mv.
If the location of the error file is not writable by the server,
the log-flushing operation fails to create a new log file. For
example, on Linux, the server might write the error log as
/var/log is owned by
root and not writable by
mysqld. For information about handling this
case, see Section 5.4.7, “Server Log Maintenance”.
If the server is not writing to a named error log file, no error log file renaming occurs when the logs are flushed.