News | August 20, 2010 | 6 Comments

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.

A screenshot explaining the fix for the wordpress posts not displaying with hostgator.

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.

Repairing a wordpress database table for the blog's posts.

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.

6 Responses to “HostGator WordPress Blog Posts Disappeared Fix”

  1. Easy Hosting
    September 23, 2010 at 7:44 am

    Where Can I get a good dedicated host?

  2. babeterminal
    January 8, 2011 at 7:06 pm

    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

  3. Eric R. W.
    January 27, 2011 at 5:21 pm

    Jackie, thats great- thanks for letting me know. 🙂

  4. Cindy
    October 4, 2011 at 7:46 pm

    Thanks so much for this!!! I really thought I’d lost everything but it worked like a charm!! You just made my day! 🙂

  5. Eric R. W.
    October 5, 2011 at 1:01 am

    Awesome. And I got to be honest with you- you made my day since it was helpful. Thanks

  6. MrTrue
    April 10, 2012 at 1:43 pm

    Worked Like A Charm

Leave a Reply