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

电玩女神 2022-07-20 15:28 310阅读 0赞

转自：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 的文章都显示不出来：

  1. # mysql -u root -p
  2. Enter password:
  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
  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:
  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!
  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

发表评论

表情：
评论列表 （有 0 条评论，310人围观）

还没有评论，来说两句吧...

相关阅读