I started having trouble with a draft post last night. It wouldn’t update and I also couldn’t delete it. Today when I was checking my blog, I noticed all my posts had disappeared. I re-installed WordPress from the dashboard but there was no change. I wasn’t in too much panic because I have a plugin that emails me a database backup every day, but I wasn’t looking forward to the hassle of trying to restore my database using sql scripts.
Thankfully 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 brought everything back.