I recently went to one of my WordPress blogs and noticed that all the posts and pages disappeared. The first thing I thought was that someone hacked my site but it turns out that the wp_posts database table needed to be fixed.
I contacted my web hosting company which was HostGator and they told me that the database table somehow crashed. They said they were running updates all day so that may have been the reason for the database fail. They fixed it right away without having to do anything but if you want to repair the table yourself, I decided to included the steps to fix it below.
First, log in to your web hosting control panel and click the phpMyAdmin under the Databases category which will display all of your databases. Then click the Databases tab and find the database which is being used for your WordPress blog. Click that database to open the list of its tables. It will look similar to the screenshot shown below once open.
If you look at the wp_posts table, you will see that it is locked and is displayed as “in use” under the Collation column as highlighted in orange below. All you need to do is check mark the box for the wp-posts table and hit Repair.
That is all it takes and your blog should be back to normal. I hope this has helped and please leave me a comment below if it did.
Where Can I get a good dedicated host?
thanks very much for this i thought i was hacked it fixed my blog all the posts and pages came back you saved the day dude
i didnt post my blog as its mature but you can find me in google with babeterminal
with thanks
jackie
Jackie, thats great- thanks for letting me know. 🙂
Thanks so much for this!!! I really thought I’d lost everything but it worked like a charm!! You just made my day! 🙂
Awesome. And I got to be honest with you- you made my day since it was helpful. Thanks
Worked Like A Charm