I thought I’d lost every post

Phew! That was close. If you visited my site over the past couple of days you, I’m sure, noticed that something was wrong, er, terribly wrong. Uh, yeah. The short story, while conducting an upgrade the table that hosts all my posts “hung up,” making all that I’ve written over the past couple of years completely inaccessible.

I have to admit, there was a moment of panic, where I thought, Shit, I just lost everything! But, I remembered, I have a back up. (That’s right, A back up — as in one back up.) My hope was short lived, though. My back up was inaccessible through the regular admin, and the file had not pulled the posts table. So, although I was able to get to the back up via FTP, my single back up was of no use to me, because it did not contain the posts table. Long story short, I was sure that I would need to start all over again, from scratch — fresh install and give up on trying to retrieve my old posts. After seeking help and some digging around, I was able to get the posts table “unstuck” and, voila, my blog is back.

The lesson: have multiple back ups, and confirm that they contain all relevant tables.