It’s your biggest nightmare; you go to your WordPress site, and there’s no content there. Did the blog goblin come and munch it all up? You log in to your dashboard, but all of the posts are all listed, like nothing happened. What sort of voodoo trickery is this!?
Well, in the few instances that I’ve dealt with this, it’s always been a single culprit and it’s actually very easy to fix. Assuming that nothing else is to blame (like a recently installed plugin, or some theme editing gone wrong), here’s where I’d start.
Check your database
Log into your web host. If you’ve got a good web host (like HostGator), you’ll be working with cPanel. Scroll down to the databases section and click on phpMyAdmin, which is the application for managing your SQL databases. Then open up your WordPress database and click on the Structure tab to review all of the tables in your database.
Scroll down to your wp_posts and wp_comments tables and look to see whether they say In Use where the Type and Collation columns are. If they do, check the box(es) at the beginning of the row and at the bottom of the table, choose Repair from the drop-down menu. You should get a little confirmation that the tables have been repaired.
Now head back to your site and reload it. Is everything back to normal? If not, I invite you to explain your circumstances below so that other users who have the same problem can find a solution.