TIPS: quickly fix MySQL database errors

After using MySQL for a long time, some problems may occur in the database. Most problems can be solved quickly through simple operations. The following describes two types of quick maintenance.

MySQL database method.

1. myisamchk

To use myisamchk, you must temporarily stop the MySQL server. For example, we want to repair the discuz database. Perform the following operations:

# Service mysql stop (stop MySQL );
# Myisamchk-r/var/lib/mysql/discuz/* MYI
# Service mysql start

Myisamchk automatically checks and fixes index errors in the data table.

2. mysqlcheck

You can use mysqlcheck to perform hotfix without stopping MySQL. The procedure is as follows:

# Mysqlcheck-r discuz .*

Note: Do not use-f to forcibly fix myisamchk or mysqlcheck. The-f parameter will be deleted when the fix fails.

Some error data to try to fix. Therefore, do not use-f unless necessary.