-備份數據庫時報錯
[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
-修復完之后就可以備份了
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
