Wordpress database corrupted error recovery procedure
Thursday, May 7th, 2009I was in for a rude shock when one of my Wordpress blogs showed a ‘wordpress database corrupted’ error message!
And mind you…
I did not have any form of backup.
And that was almost 24 months of blog posts… all gone!
As I fiddled around, I found the solution to solve this ‘wordpress database corrupted’ error. So, here’s how you can resolve this:
The first thing you should do is to go back to your blog and observe the error closely. It does not matter if you don’t understand what is MySQL or php or programming. Just watch out for the name of the database that is corrected. For example, mine was ‘wp_posts’
The next thing to do is then to login to the cPanel of your web host. In case you’re not sure how to do that, the typical URL to access is http://
After you logged in, follow these steps:
FIRST - Scroll around to look for something called phpMyAdmin and click on it to launch the program:
SECOND - Scroll down and click to select the table (eg. wp_posts) that is corrupted
THIRD - Click the drop down menu and then click on ‘Repair table’ to initiate the repair process.
And voila! your blog will be up and running!
