Database » WordPress database error Table ‘./db/wp_options’ is marked as crashed and should be repaired [✔️ SOLVED]

WordPress database error Table ‘./db/wp_options’ is marked as crashed and should be repaired [✔️ SOLVED]

Here are 4 different methods to fix the scary-looking error: “WordPress database error Table ‘./db/wp_options’ is marked as crashed and should be repaired”.

image 21 1024x517 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

NOTE: It is critically important that you backup your database before performing any of the following suggestions. You’re fully responsible for undertaking this yourself, I can’t be held responsible if you break anything.


Step 1. Log in to your phpMyAdmin or connect to it via your cPanel back-end

image 22 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 2. Select the database with the crashed table

image 23 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 3. Put a checkmark next to each crashed table or select them all

image 24 1024x639 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 4. Select “Repair table” from the “With selected:” drop-down at the bottom of the list.

image 25 1024x691 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Let phpMyAdmin do its thing.

If the database table engine is MyISAM the check was successful:

image 27 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

but if the engine is InnoDB then the repair will fail with the error message: The storage engine for the table doesn’t support repair

image 26 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

If Repair does not work and the table is still crashed, try the following:


Step 1. Log in to your phpMyAdmin or connect to it via your cPanel back-end

image 22 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 2. Select the database with the crashed table

image 23 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 3. Click on the crashed table name

image 28 1024x413 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 4. Click on the image 29 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED] tab

Step 5. Under Table options change the Storage Engine from MyISAM to InnoDB or vice versa.

image 30 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 6. Click on the image 31 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED] button under Table options section

image 32 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]


The table contains rows that have crashed, so exporting the table’s content will export all rows besides those that have crashed. And if the table’s crashing rows aren’t essential to the functioning of WordPress itself, such as transients, plugin settings, etc. – this will then put an end to the problem.

See also  How to Clean 🔴 cofounderspecials.com Malware

Step 1. Log in to your phpMyAdmin or connect to it via your cPanel back-end

image 22 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 2. Select the database with the crashed table

image 23 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 3. Click on the crashed table name

image 28 1024x413 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 4. Click on the image 33 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 5. Click on the image 31 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED] button


After the table content was successfully exported and saved as a file on your device, you need to truncate the table (delete all content) and re-import the downloaded file.

Step 6. click on the image 29 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED] tab

Step 7. Scroll down to the bottom and click on the Empty the table (TRUNCATE) link

image 34 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 8. Click OK on the confirmation popup

image 35 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

and you will see the confirmation message:

image 36 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Now you need to import back the downloaded file to the table.

Step 9. Click on the image 37 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 10. Click on Choose FIle then select the exported file and click on Open.

image 38 1024x497 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Step 5. Click on the image 31 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED] button at the bottom and wait for the import to finish.

image 39 - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

Backups are important, and if you have regular daily backups you can easily restore the crashed table from the backup.

The restore process is different depending on the backup solution of plugin that you use.

Was this post helpful?

Leave a Comment

I enjoy constructive responses and professional comments to my posts, and invite anyone to comment or link to my site.

Recommended