Translate
Meta
Archives
Social Networks
Spam Blocked

278,189 spam comments

blocked by
Akismet

Wordpress is marked as crashed and should be repaired

(1 votes, average: 5 out of 5)

Loading ...

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Bad things can happen to good blogs, you should live by that motto. I have said it time and time again, but you don’t know how well you live it until something really does go bad. Earlier today I was greeted with the “your Wordpress such and such database was marked as crashed and should be repaired”. For all of you that will see this error all is not lost as opposed to what many other sites will tell you. Simply put your MySQL database has become corrupted. This seems to be happening more and more lately, just try doing a search for the errors. Many people just throw their hands up in the air and shrug their shoulders loosing months and maybe even years of data.

The first thing you should do if you see an error like this is to read it. Simply put many people see an error and freak out. Look at what Wordpress is trying to tell you. Most likely your MySQL (the back end to Wordpress) tables have become corrupted and you need to do what Wordpress says and repair them.

The second is to log into your CPanel (if you have one, contact your host to skip this step) and look for “MySQL Databases”, scroll down to the bottom of your screen and you will see “phpMyAdmin”.

Click on phpMyAdmin, when it loads in your browser (on version 2.9.0.2) you will see a dropdown menu to your left. Click on it until you get to the database that looks like shorthand for Wordpress (like wrdpr**).

Here you will see all of the databases that make up the backend of Wordpress, looks complex doesn’t it? Its not trust me, these are just relational databases like any other and since your Wordpress told you to “repair” your database find the database that went awry and check it, check them all if you are unsure, there is a “Check all” button.

Under the “Check All” button you should see a “With Selected” drop down. In that menu you will see “Repair Table”. Click on that and wait.

Once done your databases should be repaired. Go to your site and take a giant sigh of relief. If it didn’t work now would be the time to call your host or try to use your backups. You did have backups didn’t you? If you did not have the Wordpress Database Backup plugin installed you should have had it installed because it comes stock with most Wordpress installs and whether you did or not a FAQ on how to backup and or restore your backup is here. If you haven’t yet you should get a third party backup solution such as BlogBackupOnline just in case everything goes bad.