Hello you can try these steps:
* Log in to your phpMyAdmin or connect to it via your cPanel / Plesk or hosting server back-end in general.
* Select the database with the crashed table.
* Put a checkmark next to each crashed table.
* Select “Repair table” from the “With selected:” drop down at the bottom of the list.
* Wait for the repair to finish.
* Check your website if it is ok.
Make sure to keep a backup first just in case it goes worse of course.
did you got why repair operation getting failed?
I am wondering that it would get cause because of Maximum execution time limit getting crossed.
If this is the reason then either you should increase Max execution time limit of the server or try WPCLI
wp db repair
WPCLI command
-
This reply was modified 6 years, 3 months ago by 1naveengiri.
-
This reply was modified 6 years, 3 months ago by 1naveengiri.
connect to phpMyAdmin
Repair table same problem
not repair this table
wp_posts: Table is marked as crashed and last repair failed
wp_options: Table is marked as crashed and last repair failed
wp_postmeta: Table is marked as crashed and last repair failed
If phpMyAdmin didn’t help at all then the only thing left is to manually log into your mysql and run the repair command from SSH or try the WP-CLI command @1naveengiri mentioned above.
If you are not comfortable with these terms or tech-wise I’d suggest asking your hosting company to help you out.
Usually though if phpMyAdmin fails then it means that everything else will probably fail as well..
Unfortunately my best guess is that hopefully you have a backup of your website / database so you can restore it into a previous state before there was a need for repair.