WordPress users are reporting that after attempts to repair their database they got ‘table is marked as crashed and last repair failed‘ error.
WordPress Database error ‘table is marked as crashed’
The exact error shared by WordPress users with the problem is “table is marked as crashed and last repair failed. WordPress will attempt to repair this table.”
The most affected database tables by users who had the problem were wp_options, wp_postmeta, and wp_term_taxonomy.
How to fix database repair error
Solution 1: Restoring Database Backup
If you have a recent backup of your database then the first step of troubleshooting the problem is to restore your database files. If you do not have any backup, contact your host and find out whether they might be having a recent backup of your website’s database.
Solution 2: Repair Database via phpMyAdmin
If the error arose because your database has been corrupted then you need to repair your MySQL database via phpMyAdmin.
Access your phpMyAdmin, select all the tables you want to repair or a specific one, then click repair table as shown in the image below.
NOTE: Please create a backup of your database before performing the operation above. You can restore your backup if your website breaks.
If you got a success message then the table has been repaired. If you are getting an error message then check if you have enough disk space. Most of the time, database tables crash because of lack of enough disk space to perform updates.
Important! It is recommended that you backup your database data before you perform any actions or changes. Without backup, you cannot recover your data if you accidentally delete them.