You Will Surely Have A Corrupted WordPress Database Issue. Here Is How You Fix it

The database is the most important component in the whole WordPress CMS. Being a database-driven CMS, everything that you do on your WP site is read from and written to the database. This means that the moment your database, or any table in the database, is corrupted (in laymen terms, it means your data is not retrievable or writeable), your website will malfunction. In the worst scenario, your website may not even be accessible and you won’t be able to login to the dashboard as well.

If you have a corrupted database issue, here are the ways to fix it.

Also read: How to Set Up WordPress Using Docker in Ubuntu

Using WP_ALLOW_REPAIR

For those who are using WordPress version 2.9 and above (if you are not, I urge you to upgrade it to the latest version now), WordPress comes with a database repair feature that allows you to repair the corrupted database without little technical knowledge.

1. Connect via FTP to your website and download the wp-config.php file. It is residing at the root folder of the WordPress installation.

2. Open the wp-config.php file with a text-editor and insert this line:

WP_ALLOW_REPAIR

to the end of the file, just before the if ( !defined('ABSPATH') ) line.

corrupted-db-wpconfig-allow-repair

3. Don’t edit or change any other stuff in the wp-config.php file, unless you know what you are doing. Save the changes and upload this file back to your server. Make sure you overwrite the existing copy in the server.

4. In your browser, go to the URL https://yoursite.com/wp-admin/maint/repair.php. Don’t forget to replace “yoursite.com” with your own website’s URL. This is what you will see.

corrupted-db-repair-db

You can click either the “Repair Database” button or the “Repair and Optimize Database” button. Both will repair your database. My preference would be the “Repair and Optimize Database” option since it optimizes your database as well.

5. You should now see a bunch of code. Scroll down to the end of the page and you should see “Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.” That’s it. Your database is now repaired.

corrupted-db-repair-completed

Reload your website to see if it is working and if you are able to login.

6. Lastly, remove the “WP_ALLOW_REPAIR” line from your “wp-config.php” file and re-upload it to your server.

Also read: How to Get a Free SSL Certificate for Your WordPress Website

What if the above method doesn’t work

If the above method doesn’t work, you can try the phpMyAdmin approach.

1. Login to your web host cPanel and open the phpMyAdmin module.

2. On the left sidebar, click to select your WordPress database. (If there are multiple databases in your phpMyAdmin and you are not sure which one belongs to your WordPress site, check your wp-config.php file for the database name).

3. If you have a good idea which table is corrupted, select that particular table by placing a check beside it. If not, simply select all the tables in the list. At the end of the table, there is a dropdown bar. Click and select “Repair table”.

corrupted-db-phpmyadmin-repair-table

phpMyAdmin will then proceed to repair your table(s). Once done, go back to your website and see if everything is working fine.

Last approach

If all else fails, I hope that you did backup your website regularly. This is where your backup database comes in useful.

Image credit: WordPress by BigStockPhoto

How To Save Highlighted Text in Firefox Into a File

2026-03-23
Researching on the Internet can sometimes be cumbersome. The Save Text To File extension for Firefox allows you to save highlighted text in any web page into a .txt file, then save it in any location on your hard drive.

What is Bitcoin And How You Can Utilize It Online

2026-03-23
Do you know that the Internet actually has its own currency. Since 2009, we can pay and get paid using Internet’s own currency – Bitcoin.

The Complete Guide to Avoid Scams on Craigslist

2026-03-23
Craigslist is a popular place for people to buy and sell stuff. It is also a good hangout for fraudster to scam the user. This guide will teach you how to avoid scams on Craigslist.

How to Create QR Codes From The Context Menu In Your Browser

2026-03-23
QR codes are becoming increasingly popular these days. In this article, we will show you how you can quickly create QR codes directly from your browser’s context menu.

3 Ways to Allow Guest Users on Google Chrome

2026-03-23
If you’re using Chrome and don’t feel like letting people poking into your privacy, here are some ways to set up guest users account in Google Chrome.

Save and Restore Groups of Tabs in Chrome with This Quick Trick

2026-03-23
Looking for a way to overcome having too many tabs open? Use this quick trick to save and restore groups of tabs in Chrome without installing an extension.

Don’t Like Gmail’s New Always Display External Images Feature? Here’s How to Disable It

2026-03-23
By default, Google has decided to make it so that Gmail will always display external images in your email. If you don’t like this, here’s how to disable it.

6 Alternative Uses of WordPress, Other Than Blogging

2026-03-23
You can be sure of one thing, Wordpress: it’s not just for blogs anymore. Here are 6 alternative uses of Wordpress that aren’t blogging.

Clef: Log In to WordPress Without Any Password

2026-03-23
Tired of typing your username and password everytime you want to login to a site? Clef is a password replacement app that allows you to login without password.

What Is the OpenSSL Heartbleed Bug and Why Should You Care?

2026-03-23
Things just don’t work the way they should in the Internet. Here are some things you should know about the OpenSSL “Heartbleed” bug and how it affects you.

How to Manually Install Extensions in Google Chrome

2026-03-23
If you want to install any extension in Google Chrome, that is not in the Chrome store, here is a way to manually install extensions in Google Chrome.

How to Enable the Firefox Quick Find Feature in Google Chrome

2026-03-23
Firefox comes with a Quick Find feature that allows you to search for text when you start typing. Here is how you can get the same feature in Google Chrome.