"MySQL" is marked as crashed and should be repaired

Source: Internet
Author: User

-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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.