【mysql】ismarkedascrashedandshouldberepaired
-备份数据库时报错
岱岳网站制作公司哪家好，找创新互联建站！从网页设计、网站建设、微信开发、APP开发、响应式网站等网站项目制作，到程序开发，运营维护。创新互联建站于2013年开始到现在10年的时间，我们拥有了丰富的建站经验和运维经验，来保证我们的工作的顺利进行。专注于网站建设就选创新互联建站。
[ERROR] /usr/sbin/MySQLd: Table './daifans/wp_options' is marked as crashed and should be repaired
- 在网上查了文档，说是表损坏，所以 WordPress 的文章都显示不出来，需要修复，修复前需要备份
我备份时也出错了，说是损坏的那个表备份不了的意思，我就用排除废表备份其他的
# mysqldump -uroot -p dbname --ignore-table=dbname.tablename --ignore-table=dbname.tablename2 --ignore-table=dbname.tablename3 > dump.sql
然后添加 –auto-repair 参数自动修复
# mysqlcheck -u root -p daifans --auto-repair
Enter password: daifans.wp_commentmeta error : Table upgrade required. Please do "REPAIR TABLE `wp_commentmeta`" or dump/reload to fix it! daifans.wp_comments error : Table upgrade required. Please do "REPAIR TABLE `wp_comments`" or dump/reload to fix it! daifans.wp_links error : Table upgrade required. Please do "REPAIR TABLE `wp_links`" or dump/reload to fix it! daifans.wp_options error : Table upgrade required. Please do "REPAIR TABLE `wp_options`" or dump/reload to fix it! daifans.wp_postmeta error : Table upgrade required. Please do "REPAIR TABLE `wp_postmeta`" or dump/reload to fix it! daifans.wp_posts error : Table upgrade required. Please do "REPAIR TABLE `wp_posts`" or dump/reload to fix it! daifans.wp_term_relationships OK daifans.wp_term_taxonomy error : Table upgrade required. Please do "REPAIR TABLE `wp_term_taxonomy`" or dump/reload to fix it! daifans.wp_terms error : Table upgrade required. Please do "REPAIR TABLE `wp_terms`" or dump/reload to fix it! daifans.wp_usermeta error : Table upgrade required. Please do "REPAIR TABLE `wp_usermeta`" or dump/reload to fix it! daifans.wp_users error : Table upgrade required. Please do "REPAIR TABLE `wp_users`" or dump/reload to fix it! Repairing tables daifans.wp_commentmeta OK daifans.wp_comments OK daifans.wp_links OK daifans.wp_options OK daifans.wp_postmeta OK daifans.wp_posts OK daifans.wp_term_taxonomy OK daifans.wp_terms OK daifans.wp_usermeta OK daifans.wp_users OK
-修复完之后就可以备份了
分享文章：【mysql】ismarkedascrashedandshouldberepaired
网页地址：http://shouzuofang.com/article/piipjj.html