-Backup Database times wrong
[ERROR]/usr/sbin/mysqld:table './daifans/wp_options ' is marked as crashed and should be repaired
-Check the document on the Internet, said that the table is damaged, so WordPress articles are not displayed, need to repair, repair needs to backup before
I also made a mistake in the backup, said that the damage to the table can not back up the meaning, I would like to use the elimination of waste table backup other
# mysqldump-uroot-p dbname--ignore-table=dbname.tablename--ignore-table=dbname.tablename2--ignore-table= Dbname.tablename3 > Dump.sql
Then add the –auto-repair parameter auto fix
# 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
-You can back up once you've finished repairing
"MySQL" is marked as crashed and should be repaired