[mysql]ERROR 1030 (HY000): Got error 127 from storage engine

MYSQL 报:ERROR 1030 (HY000): Got error 127 from storage engine
[quote]
[songxinfeng@localhost ~]$ perror 127
MySQL error code 127: Record-file is crashed
[/quote]
记录文件崩溃！  [s:6]

检查表
[quote]
mysql> check table wf_entity;
+--------------------------+-------+----------+----------------------------------------------------------+
| Table                    | Op    | Msg_type | Msg_text                                                 |
+--------------------------+-------+----------+----------------------------------------------------------+
| test_ztoa_sale.wf_entity | check | warning  | 2 clients are using or haven't closed the table properly |
| test_ztoa_sale.wf_entity | check | error    | Size of datafile is: 714660         Should be: 753468    |
| test_ztoa_sale.wf_entity | check | error    | Corrupt                                                  |
+--------------------------+-------+----------+----------------------------------------------------------+

[/quote]
修复
[quote]
mysql> repair table wf_entity;
+--------------------------+--------+----------+------------------------------------------+
| Table                    | Op     | Msg_type | Msg_text                                 |
+--------------------------+--------+----------+------------------------------------------+
| test_ztoa_sale.wf_entity | repair | warning  | Number of rows changed from 7751 to 7393 |
| test_ztoa_sale.wf_entity | repair | status   | OK                                       |
+--------------------------+--------+----------+------------------------------------------+
[/quote]

ok!
[s:2]

mysql问题解决！

[code]
使用mysql的perror命令快速排错：再使用mysql的时候经常会返回一个错误代码,有些错误代码有提示,有的则没有,那么除了查看日志之外还有没别的办法呢,答案是肯定的,mysql提供了perror命令来打印错误信息例如:我们得到错误代码为13的话执行:
# perror 13
Error code 13: Permission denied
所以错误的原因是因为mysql没有权限读取数据库,依此类推
[/code]

修复完再优化一下!