[mysql] is marked as crashed and should be repaired

-error backing up the database

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

-checked the documents on the Internet and said that the table was damaged, so the articles in WordPress could not be displayed and needed to be repaired. Backup was needed before repair.

I also made a mistake when I backed up, saying that the damaged table could not be backed up, so I used to exclude the waste table to back up the other ones.

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

Then add the-auto-repair parameter to automatically repair

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

Enter password:daifans.wp_commentmetaerror: Table upgrade required. Please do "REPAIR TABLE `commentmeta`" or dump/reload to fix itinerdaifans.wpspeak commentserror: Table upgrade required. Please do "REPAIR TABLE `comments`" or dump/reload to fix itinerdaifans.wpspeak linkserror: Table upgrade required. Please do "REPAIR TABLE `wp_ Links`" or dump/reload to fix itinerary daifans.wproomoptionserror: Table upgrade required. Please do "REPAIR TABLE `wp_ options`" or dump/reload to fix itinerary daifans.wpresume postmetaerror: Table upgrade required. Please do "REPAIR TABLE `postmeta`" or dump/reload to fix itinerary daifans.wproompostserror: Table upgrade required. Please do "REPAIR TABLE `wp_ posts`" or dump/reload to fix itinerary daifans.wpspeak terms OKdaifans.wp_term_taxonomyerror: Table upgrade required. Please do "REPAIR TABLE `taxonomy`" or dump/reload to fix itinerary daifans.wproomtermserror: Table upgrade required. Please do "REPAIR TABLE `wp_ terms`" or dump/reload to fix itinerary daifans.wpspeak usermetaEmission error: Table upgrade required. Please do "REPAIR TABLE `UserMeta`" or dump/reload to fix itinerdaifans.wproomuserserror: Table upgrade required. Please do "REPAIR TABLE `wp_ users`" or dump/reload to fix itinerary Rependental 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

-after the repair, you can back up.