Two tips for MySQL table repair

We often use the MySQL table repair method. Here are two tips for restoring tables in MySQL. I hope this will help you learn how to fix tables in MySQL.

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 ways to restore a MySQL table.

1. myisamchk

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

# Service mysql stop (stop MySQL)
# Myisamchk-r/datawhere/blog/* 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: (repair the blog Library)

# Mysqlcheck-r-uroot-p blog

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.

Mysql temporary table usage

MySQL Stored Procedure for table splitting

In-depth discussion on MySQL Lock Mechanism

Detailed description of MySQL Data Table types

Enumeration in the MySQL Field