MySQL repairs the myisam table

The actual instance:

Today, I found that the website data was abnormal. I checked the database and encountered the following error when operating a table (tbl_test:

Table '. \ mydb \ tbl_test' is marked as crashed and shoshould be retried red

You can use phpmyadmin to fix the problem!

Use the myisamchk that comes with mysql as follows:

Locate the location of the error table (mysql Data in linux is usually stored in/var/lib/mysql)

Shell> cd/var/lib/mysql/mydb;

Shell> myisamchk-r q tbl_test)

If the previous step fails, execute the next step.

Shell> myisamchk-r tbl_test; (inconsistent data and indexes are deleted and re-built)

If it fails again, execute the next step.

Shell> myisamchk -- safe-recover tbl_test;

Note: Before using myisamchk, make sure that mysqld is not accessing the table to be checked. It is best to stop mysqld.