Website Solutions Expert

Help, My Blog Posts Have Disappeared!

Have you suddenly discovered that your posts and pages have all disappeared? Your blog theme/template is still there but it’s saying no posts found?

This has happened to four clients in the last week, three on Hostgator and one on another. I know Hostgator are gradually upgrading all their servers and I’ve no idea if this is the cause but wouldn’t be surprised.

The reason (in these cases) has been a crashed wp_posts database table. The error message given (if you get one at all in your theme or admin menu) is often: “wp_posts is marked as crashed and should be repaired”. To fix is pretty simple. Login to your host’s control panel and go to the phpMyAdmin option. This brings up a list of your databases. Select the one you’re using for WordPress to see the WordPress tables in that database. A list like this will appear (the actual number and name of some tables will vary depending on the plugins used):

Corrupted table

(Click to enlarge)

You can see the problem here, wp_posts is labeled as “in use” and is locked. To repair, simply check the box next to wp_posts and select Repair table, as in the image below.



(Click to enlarge)

You should then get a success message and your posts will have reappeared. If not then you may have a bigger problem, but at least you have a recent backup. Right?!

83 Responses to Help, My Blog Posts Have Disappeared!

  1. THANK YOU THANK YOU THANK YOU!!!!!!!!!!
    This saved my sanity, got my posts back!!

  2. [...] followed a tutorial from BlogTechGuy.com which was amazingly helpful and eventually got the sites content back up and running after [...]

  3. couponfreaks says:

    Amazing, thank you very very much for this awesome tutorial, very impressed, i thought my content had gone but by following your tutorial my content is now back up. Thanks so much!

  4. carstory says:

    Great and awesome post ever! I’m impress, I learn a lot of things here and it is truly great. Thanks for sharing it!

  5. mississippimom says:

    Thank you so much!

  6. mississippimom says:

    oh my goodness! Thank you!!!

  7. Rintesh says:

    Thanks a lot Joel…you made my day! I

  8. xescx says:

    Hi there,

    Many thanks for this entry. I thought my 10 years worth of blog postings were all done the drain! 

  9. Oh my goodness – thank God I found this post! Thank you so much xxxx

  10. Chaitanya.GK says:

    Thanks Williams….!!! awesome post….I bet it might have saved tons of blogs :)

  11. trostle says:

    Holy crap, I freaked out for a minute. :) Thanks so much!

  12. trostle says:

    Holy crap, I freaked out for a minute. :) Thanks so much!

  13. [...] I fought a very helpful post today that got my blog back up and running in seconds.  A simple repair on the wp_posts table [...]

  14. Hi Joel, You saved me from a meltdown! I am citing your post on my blog and crediting you for the save.
    Thanks!

  15. Thank you very much :)

  16. Thank you for saving me from a heart attack! Yours was the only data I was able to find on this. I called Host Gator and the tech fixed it in 1 minute. You get a red rose!

  17. Thank you, unbelievably helpful. Just saved a client from a whole lot of frustration!

  18. Ken says:

    Thanks Joel! I was able to restore my posts but am still getting error messages for all the pages on my site. Is there another table that manages the pages or links to the pages?

    • Joel says:

      Hi Ken. Posts and pages are held in the same table, so what error message are you getting? Is it for all Pages? There may be some problem with the table still, but posts and pages are almost the same in the database so there is something funny going on.

    • Ken says:

      Thanks for replying Joel. Turns out my PermaLink Structure got changed. Had to go into my .htaccess file and change permission to 666, then go into WP_Settings_Permalinks and restore the custom structure I had previously setup. It was a simple fix that I found at Squidoo.com.

      Thanks for helping – I had a small heart attack when I first discovered the problem.

    • Joel says:

      I appreciate the update Ken, glad you got it sorted :)

  19. Ken says:

    Thanks Joel! I was able to restore my posts but am still getting error messages for all the pages on my site. Is there another table that manages the pages or links to the pages?

    • Hi Ken. Posts and pages are held in the same table, so what error message are you getting? Is it for all Pages? There may be some problem with the table still, but posts and pages are almost the same in the database so there is something funny going on.

    • Ken says:

      Thanks for replying Joel. Turns out my PermaLink Structure got changed. Had to go into my .htaccess file and change permission to 666, then go into WP_Settings_Permalinks and restore the custom structure I had previously setup. It was a simple fix that I found at Squidoo.com.

      Thanks for helping – I had a small heart attack when I first discovered the problem.

    • I appreciate the update Ken, glad you got it sorted :)

  20. Shannan says:

    I was able to recover the pages as well. THANKS AGAIN! YOU ARE A BLOG SAVER!!!!!!!!!!!!!!!!!!!!!!!!!!!111

  21. Shannan says:

    I was able to recover the pages as well. THANKS AGAIN! YOU ARE A BLOG SAVER!!!!!!!!!!!!!!!!!!!!!!!!!!!111

  22. Shannan says:

    Thank you so much! This worked and brought my posts back is there a similar way to bring the pages of the blog back!

  23. Shannan says:

    Thank you so much! This worked and brought my posts back is there a similar way to bring the pages of the blog back!

  24. Tony says:

    i found it, the problem was revver video plugin, even though it was installed and i deactivated all plugins, revver was the problem just by being there!

    • Joel says:

      Great, thanks for letting me know you solved it Tony! You did the right thing deactivating the plugins, but you never can tell. Also if ever doing an upgrade, if there are new versions of any plugins, always upgrade those before upgrading WordPress. Glad it’s working for you now!

  25. Tony says:

    i found it, the problem was revver video plugin, even though it was installed and i deactivated all plugins, revver was the problem just by being there!

    • Great, thanks for letting me know you solved it Tony! You did the right thing deactivating the plugins, but you never can tell. Also if ever doing an upgrade, if there are new versions of any plugins, always upgrade those before upgrading WordPress. Glad it’s working for you now!

  26. Tony says:

    It seems i have a bigger problem.
    they want to charge me too for to get restored to the last time they did a back up which was sunday, thats 3 days blogging lost and some long posts were in there too.
    They also didnt see what the fault was.
    i have no idea if it will happen again.
    Any suggestions?

  27. Tony says:

    It seems i have a bigger problem.
    they want to charge me too for to get restored to the last time they did a back up which was sunday, thats 3 days blogging lost and some long posts were in there too.
    They also didnt see what the fault was.
    i have no idea if it will happen again.
    Any suggestions?

  28. Kevin says:

    If you think Joel’s free advice is good (and it is), try hiring him. BEST decision I ever made on the web!

  29. Kevin says:

    If you think Joel’s free advice is good (and it is), try hiring him. BEST decision I ever made on the web!

  30. I was working on my site when suddenly all the pages and all the posts were gone … just vanished.

    By Googling “my pages and posts have disappeared” I found this site and I want to say thank you Joel for having a solution at hand here.

    One thing though … when I got into my cpanel I couldnt find the “myphpadmin” anywhere. After investigation I found out that my problem was that I was using the “x”-theme in my cpanel, which apparantly doesnt have this feature. By changing it to “x3″-cpanel theme, the “myphpadmin” appeared and I was able to fix the problem.

    Thanks again Joel.

    • Joel says:

      Good point, I hadn’t though of the cPanel themes thanks. You can also find phpMyAdmin under MySQL databases at the very bottom of that page. Glad you got it fixed!

  31. I was working on my site when suddenly all the pages and all the posts were gone … just vanished.

    By Googling “my pages and posts have disappeared” I found this site and I want to say thank you Joel for having a solution at hand here.

    One thing though … when I got into my cpanel I couldnt find the “myphpadmin” anywhere. After investigation I found out that my problem was that I was using the “x”-theme in my cpanel, which apparantly doesnt have this feature. By changing it to “x3″-cpanel theme, the “myphpadmin” appeared and I was able to fix the problem.

    Thanks again Joel.

    • Good point, I hadn’t though of the cPanel themes thanks. You can also find phpMyAdmin under MySQL databases at the very bottom of that page. Glad you got it fixed!

  32. tom b says:

    Thanks Joel, great fix, wasn’t thinking clearly enough to get there on my own. I’d just sent out a load of marketing material yesterday then my site crashed! I’m with united hosting by the way.

  33. tom b says:

    Thanks Joel, great fix, wasn’t thinking clearly enough to get there on my own. I’d just sent out a load of marketing material yesterday then my site crashed! I’m with united hosting by the way.

  34. Edie Dykeman says:

    Joel, you are a lifesaver. As you know from my emails, I was in a panic and you graciously saved the day – on a Sunday, no less. Thanks for everything!

  35. Edie Dykeman says:

    Joel, you are a lifesaver. As you know from my emails, I was in a panic and you graciously saved the day – on a Sunday, no less. Thanks for everything!

  36. Diego says:

    Thanks this worked great!! I was in panic!!

  37. Diego says:

    Thanks this worked great!! I was in panic!!

  38. Phew! I sure am glad I found this post. 160+ articles sent to oblivion and I thought that I was going to have to replace them all. I’m with Hostgator too but I haven’t ever had any problems with them before.

    Thanks for the info

  39. Phew! I sure am glad I found this post. 160+ articles sent to oblivion and I thought that I was going to have to replace them all. I’m with Hostgator too but I haven’t ever had any problems with them before.

    Thanks for the info

  40. candy says:

    OMG you just saved me from a massive panic attack. It worked exactly as you said. I’ve bookmarked this in case it happens again.

  41. candy says:

    OMG you just saved me from a massive panic attack. It worked exactly as you said. I’ve bookmarked this in case it happens again.

  42. Carrie says:

    Big thanks. I thought I was hacked but your solution fixed everything. I am also on Hostgator.

  43. Carrie says:

    Big thanks. I thought I was hacked but your solution fixed everything. I am also on Hostgator.

  44. Bunnygotblog says:

    Thanks this is great.This has happened to me also.

  45. Bunnygotblog says:

    Thanks this is great.This has happened to me also.

  46. Lance says:

    Hi Joel,

    Yes happended to me too at same time – hostgator was my host. and i think many many others, thx for the guide.

    Lance

  47. Lance says:

    Hi Joel,

    Yes happended to me too at same time – hostgator was my host. and i think many many others, thx for the guide.

    Lance

  48. [...] just before I started to cry I found this post by the Blog Tech Guy. And I followed his directions (once I remembered the password to my hosting [...]

  49. Eve says:

    THANK YOU! This just happened to me and I was freaking out until I read this, it worked perfectly- all is right in the world now!

  50. Eve says:

    THANK YOU! This just happened to me and I was freaking out until I read this, it worked perfectly- all is right in the world now!

Leave a Reply