mysql报错1194_ERROR 1194 (HY000): Table 't1' is marked as crashed and should be repaired

今天测试mysql，发现一个表出现了以下报错

ERROR 1194 (HY000): Table 't1' is marked as crashed and should be repaired

在网上搜有些说需要通下面方法进行修复

[root@localhost data]# myisamchk -f ./test2/*.MYI

Checking MyISAM file: ./test2/t1.MYI

Data records:   24926   Deleted blocks:       0

- check file-size

myisamchk: error: Size of datafile is: 73                Should be: 174482

- recovering (with keycache) MyISAM-table './test2/t1.MYI'

Data records: 24926

Data records: 5

---------

Checking MyISAM file: ./test2/t2.MYI

Data records:  482688   Deleted blocks:       0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

---------

Checking MyISAM file: ./test2/t4.MYI

Data records:  482688   Deleted blocks:       0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

---------

Checking MyISAM file: ./test2/t5.MYI

Data records:  482688   Deleted blocks:       0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check record links

然后在mysql 里使用repair中进行修复，成功。

mysql> repair table cmxt.cm_user_pref;

+-------------------+--------+----------+----------+

| Table             | Op     | Msg_type | Msg_text |

+-------------------+--------+----------+----------+

| cmxt.cm_user_pref | repair | status   | OK       |

+-------------------+--------+----------+----------+

后来经过实验发现

首先检查check table t1

mysql> check table t1;

+----------+-------+----------+---------------------------------------------------+

| Table    | Op    | Msg_type | Msg_text                                          |

+----------+-------+----------+---------------------------------------------------+

| test2.t1 | check | error    | Size of datafile is: 73         Should be: 174482 |

| test2.t1 | check | error    | Corrupt                                           |

+----------+-------+----------+---------------------------------------------------+

2 rows in set (0.00 sec)

然后再使用myisamchk来修复

[root@localhost mysql]# myisamchk -f ./data/test2/t1.MYI

Checking MyISAM file: ./data/test2/t1.MYI

Data records:   24926   Deleted blocks:       0

myisamchk: warning: Table is marked as crashed

- check file-size

myisamchk: error: Size of datafile is: 73                Should be: 174482

- recovering (with keycache) MyISAM-table './data/test2/t1.MYI'

Data records: 24926

Data records: 5

然后再查看t1表

mysql> select * from t1; +-------------+ | str_number  | +-------------+ |        NULL | |        NULL | | -1774844896 | |        NULL | |        NULL | +-------------+ 5 rows in set (0.00 sec)