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

学习NO.1

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

1. # mysql -u root -p
   
2. Enter password:
   
3. 
   
4. mysql> use wordpress;
   
5. Reading table information for completion of table and column names
   
6. You can turn off this feature to get a quicker startup with -A
   
7. 
   
8. Database changed
   
9. mysql> select * from wp_posts;
   
10. ERROR 145 (HY000): Table './wordpress/wp_posts' is marked as crashed and should be repaired
    
11. mysql> Bye

复制代码

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

1. # mysqlcheck -u root -p wordpress
   
2. Enter password:

复制代码

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

1. # mysqldump -u root -p wordpress > wordpress.sql
   
2. Enter password:
   
3. 
   
4. # mysqlcheck -u root -p wordpress --auto-repair
   
5. Enter password:
   
6. wordpress.wp_commentmeta
   
7. error    : Table upgrade required. Please do "REPAIR TABLE `wp_commentmeta`" or dump/reload to fix it!
   
8. wordpress.wp_comments
   
9. error    : Table upgrade required. Please do "REPAIR TABLE `wp_comments`" or dump/reload to fix it!
   
10. wordpress.wp_links
    
11. error    : Table upgrade required. Please do "REPAIR TABLE `wp_links`" or dump/reload to fix it!
    
12. wordpress.wp_options
    
13. error    : Table upgrade required. Please do "REPAIR TABLE `wp_options`" or dump/reload to fix it!
    
14. wordpress.wp_postmeta
    
15. error    : Table upgrade required. Please do "REPAIR TABLE `wp_postmeta`" or dump/reload to fix it!
    
16. wordpress.wp_posts
    
17. error    : Table upgrade required. Please do "REPAIR TABLE `wp_posts`" or dump/reload to fix it!
    
18. wordpress.wp_term_relationships                OK
    
19. wordpress.wp_term_taxonomy
    
20. error    : Table upgrade required. Please do "REPAIR TABLE `wp_term_taxonomy`" or dump/reload to fix it!
    
21. wordpress.wp_terms
    
22. error    : Table upgrade required. Please do "REPAIR TABLE `wp_terms`" or dump/reload to fix it!
    
23. wordpress.wp_usermeta
    
24. error    : Table upgrade required. Please do "REPAIR TABLE `wp_usermeta`" or dump/reload to fix it!
    
25. wordpress.wp_users
    
26. error    : Table upgrade required. Please do "REPAIR TABLE `wp_users`" or dump/reload to fix it!
    
27. 
    
28. Repairing tables
    
29. wordpress.wp_commentmeta                       OK
    
30. wordpress.wp_comments                          OK
    
31. wordpress.wp_links                             OK
    
32. wordpress.wp_options                           OK
    
33. wordpress.wp_postmeta                          OK
    
34. wordpress.wp_posts                             OK
    
35. wordpress.wp_term_taxonomy                     OK
    
36. wordpress.wp_terms                             OK
    
37. wordpress.wp_usermeta                          OK
    
38. wordpress.wp_users                             OK

复制代码

推介阅读：

关于Table xxx is marked as crashed and should be repaired 的解决方法
mysql错误：……is marked as crashed and should be repaired！突然断电引起

快速解决"is marked as crashed and should be repaired"故障  http://www.daoqin.net/thread-1640-1-1.html

解决 MySQL 的 Table is marked as crashed and should be repaired 问题 http://www.daoqin.net/thread-1643-1-1.html

道勤主机提供365天*24小时全年全天无休、实时在线、零等待的售后技术支持。竭力为您免费处理您在使用道勤主机过程中所遇到的一切问题! 如果您是道勤主机用户，那么您可以通过QQ【792472177】、售后QQ【59133755】、旺旺【诠释意念】、微信：q792472177免费电话、后台提交工单这些方式联系道勤主机客服！ 如果您不是我们的客户也没问题，点击页面最右边的企业QQ在线咨询图标联系我们并购买后，我们为您免费进行无缝搬家服务，让您享受网站零访问延迟的迁移到道勤主机的服务！