Movatterモバイル変換

If you flush the error log using aFLUSH ERROR LOGS orFLUSH LOGS statment, or amysqladmin flush-logs command, 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 ofhost_name.err, use the following commands to rename the file and create a new one:

mvhost_name.errhost_name.err-oldmysqladmin flush-logs errormvhost_name.err-oldbackup-directory

On Windows, userename rather thanmv.

If the location of the error log 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 to the/var/log/mysqld.log file, where the/var/log directory is owned byroot and is not writable bymysqld. For information about handling this case, seeSection 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 error log is flushed.