"MySQL" is marked as crashed and should be repaired

-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

1. 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

   
   

2. 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