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 the table you want to repair, then select all tables and 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.
WARNING! Database repair without a backup is not recommended at all. You can lose all your posts or pages without any option to recover them.
Got questions on blogging tools, this post, or anything else related to website technologies, we are responding at Blogiestools Ask Community.
