解决 MySQL 的 Table is marked as crashed and should be repaired 问题

转自：http://www.vpsee.com/2013/08/how-to-fix-mysql-table-is-marked-as-crashed-and-should-be-repaird/

---

昨天一位 VPS 客户说他的 WordPress 博客没了，网站可以打开，但是文章都没了，怀疑被黑。我们登陆客户 VPS 后没发现被黑迹象，然后进入 MySQL 数据库发现 Table ‘./wordpress/wp_posts’ is marked as crashed and should be repaired 错误，因为 wp_posts 表被损坏了，所以 WordPress 的文章都显示不出来：

# mysql -u root -pEnter password:mysql> use wordpress;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select * from wp_posts;ERROR 145 (HY000): Table './wordpress/wp_posts' is marked as crashed and should be repairedmysql> Bye

修复 MySQL 数据库数据表问题可以由 mysqlcheck 来解决，先用 mysqlcheck 查看一下：

# mysqlcheck -u root -p wordpressEnter password:

然后添加 –auto-repair 参数自动修复，最好修复前备份一下数据库：

# mysqldump -u root -p wordpress > wordpress.sqlEnter password:# mysqlcheck -u root -p wordpress --auto-repairEnter password:wordpress.wp_commentmetaerror    : Table upgrade required. Please do "REPAIR TABLE `wp_commentmeta`" or dump/reload to fix it!wordpress.wp_commentserror    : Table upgrade required. Please do "REPAIR TABLE `wp_comments`" or dump/reload to fix it!wordpress.wp_linkserror    : Table upgrade required. Please do "REPAIR TABLE `wp_links`" or dump/reload to fix it!wordpress.wp_optionserror    : Table upgrade required. Please do "REPAIR TABLE `wp_options`" or dump/reload to fix it!wordpress.wp_postmetaerror    : Table upgrade required. Please do "REPAIR TABLE `wp_postmeta`" or dump/reload to fix it!wordpress.wp_postserror    : Table upgrade required. Please do "REPAIR TABLE `wp_posts`" or dump/reload to fix it!wordpress.wp_term_relationships                OKwordpress.wp_term_taxonomyerror    : Table upgrade required. Please do "REPAIR TABLE `wp_term_taxonomy`" or dump/reload to fix it!wordpress.wp_termserror    : Table upgrade required. Please do "REPAIR TABLE `wp_terms`" or dump/reload to fix it!wordpress.wp_usermetaerror    : Table upgrade required. Please do "REPAIR TABLE `wp_usermeta`" or dump/reload to fix it!wordpress.wp_userserror    : Table upgrade required. Please do "REPAIR TABLE `wp_users`" or dump/reload to fix it!Repairing tableswordpress.wp_commentmeta                       OKwordpress.wp_comments                          OKwordpress.wp_links                             OKwordpress.wp_options                           OKwordpress.wp_postmeta                          OKwordpress.wp_posts                             OKwordpress.wp_term_taxonomy                     OKwordpress.wp_terms                             OKwordpress.wp_usermeta                          OKwordpress.wp_users                             OK