【mysql】 is marked as crashed and should be repaired

標籤：wordpress   password   required   upgrade   should   

-備份資料庫時報錯

[ERROR] /usr/sbin/mysqld: Table ‘./daifans/wp_options‘ is marked as crashed and should be repaired

- 在網上查了文檔，說是表損壞，所以 WordPress 的文章都顯示不出來，需要修複，修複前需要備份

1. 我備份時也出錯了，說是損壞的那個表備份不了的意思，我就用排除廢表備份其他的

   # mysqldump -uroot -p  dbname --ignore-table=dbname.tablename --ignore-table=dbname.tablename2 --ignore-table=dbname.tablename3 > dump.sql

   
   

2. 然後添加 –auto-repair 參數自動修複

   # mysqlcheck -u root -p daifans --auto-repair

Enter password:daifans.wp_commentmetaerror    : Table upgrade required. Please do "REPAIR TABLE `wp_commentmeta`" or dump/reload to fix it!daifans.wp_commentserror    : Table upgrade required. Please do "REPAIR TABLE `wp_comments`" or dump/reload to fix it!daifans.wp_linkserror    : Table upgrade required. Please do "REPAIR TABLE `wp_links`" or dump/reload to fix it!daifans.wp_optionserror    : Table upgrade required. Please do "REPAIR TABLE `wp_options`" or dump/reload to fix it!daifans.wp_postmetaerror    : Table upgrade required. Please do "REPAIR TABLE `wp_postmeta`" or dump/reload to fix it!daifans.wp_postserror    : Table upgrade required. Please do "REPAIR TABLE `wp_posts`" or dump/reload to fix it!daifans.wp_term_relationships                OKdaifans.wp_term_taxonomyerror    : Table upgrade required. Please do "REPAIR TABLE `wp_term_taxonomy`" or dump/reload to fix it!daifans.wp_termserror    : Table upgrade required. Please do "REPAIR TABLE `wp_terms`" or dump/reload to fix it!daifans.wp_usermetaerror    : Table upgrade required. Please do "REPAIR TABLE `wp_usermeta`" or dump/reload to fix it!daifans.wp_userserror    : Table upgrade required. Please do "REPAIR TABLE `wp_users`" or dump/reload to fix it!Repairing tablesdaifans.wp_commentmeta                       OKdaifans.wp_comments                          OKdaifans.wp_links                             OKdaifans.wp_options                           OKdaifans.wp_postmeta                          OKdaifans.wp_posts                             OKdaifans.wp_term_taxonomy                     OKdaifans.wp_terms                             OKdaifans.wp_usermeta                          OKdaifans.wp_users                             OK

    

-修複完之後就可以備份了

【mysql】 is marked as crashed and should be repaired