MySQL Repair table

database table xxx is marked as crashed and should be repaired error resolution server Power off and other reasons may cause data table corruption, resulting in access to prompt: Table xxx is marked as crashed and should be repaired where xxx is the name of the table.

Find the corresponding table, using repair table table_name; To repair

Mysql> SELECT * fromLog_check_user; ERROR1194 (HY000): Table'Log_check_user' is   marked as crashed   and should be repairedMySQL>repair table Log_check_user;+----------------------+--------+----------+-------------------------------------------------+| Table | Op | Msg_type | Msg_text |+----------------------+--------+----------+----------------------------- --------------------+| Sg456.log_check_user | Repair | info | Wrong bytesec:0-0-0 at 68974624; Skipped | | Sg456.log_check_user | Repair | Warning | Number of rows changed from428999 to 428998 | | Sg456.log_check_user | Repair | Status | OK |+----------------------+--------+----------+----------------------------- --------------------+3 rowsinchSet (24.87sec) MySQL> select * fromLog_check_user;

MySQL Repair table