MySQL database log file maintenance

[little-Jacqueline]

Hi all,

As Log File Restoration Database an important reference data, so the log file Maintenance also has very important significance. When MySQL used in conjunction with the log files, i sometimes want to remove / backup old log files and tell MySQL to start recording in the new file. This involves opening of the new log files, including updating logs and conventional logs. I want to know that How to maintenance MySQL database log file. Thanks in advance.

[Zecho]

If you are using only an update log, you only need to empty the log file, and then remove the old update log files to a backup, and then enable the new update log. With the following method can be forced Servers Opening of the new update log:

# mysqladmin flush-logs

You generally need to use the command line to provide the database user:

mysqladmin-u root-p flush-logs

Check and reply.

[Reegan]

You generally need to use the command line to provide the database user:

mysqladmin-u root-p refresh

If you are using MySQL 3.21 or earlier versions, you must use mysqladmin refresh.
# SQL commands

FLUSH LOGS

# restart the server
These methods have such features:Close and then open the standard and update log files. If you do not specify an extension of the update log files, the new update log file extension numbers will be relatively earlier paper plus 1.

mysql> FLUSH LOGS;

Check and reply.

[opaper]

You can use the new conventional log. This method can also force an update of conventional logging.Must be prepared to back up the conventional logs, the steps may be more complex:

# Cd mysql-data-directory
#Mv mysql.log mysql.old
# Mysqladmin flush-tables

Then do a backup and delete the "mysql.old".

[MindSpace]

A log flushing operation does the following:
# If universal query logging (--log) or slow query logging (--log-slow-queries) to a log file is enabled, the server shut and reopens the common query log file or slow query log file.
# If binary logging (--log-bin) is used, the server close the current log file and opens a new log file with the subsequently sequence number.
# If the server was known an error log file name with the --log-error option, it renames the error log with the suffix -old and creates a new empty error log file.