导航

MySQL修复表数据

Posted on 2011-02-14 15:57  Enrico Zhang  阅读(223)  评论(0)  编辑  收藏  举报

Table xxx is marked as crashed and should be repaired

关键字: table xxx is marked as crashed and should be repaired

 Caused by: java.sql.SQLException: Table '表名' is marked as crashed and should be repaired

解决办法：

1 ./myisamchk -c -r 数据库表MYI文件的路径(例如：/home/mysql/var/crawlerfeedsky/aaaa.MYI) 
2 如果还不行，就-f 强制修复