Notice: This entry was published 5 years ago and may no longer reflect my views today.
Well, that was scary. My blog was gone the whole of last night because I’m an idiot and made a rookie mistake: I messed with my databases without backing up first. I mentioned in my About page about my old blog archives being lost in a hard drive somewhere in my room. I found it a few days ago (looking for something else) at the bottom of my jeans drawer. Why it was there, I have no idea, but I never found the white jeans I was looking for so… yeah.
I decided to import my old archive into phpMyAdmin last night, once again, without backing up first. It imported just fine, but then my blog had a redirect loop and I couldn’t access my control panel. I decided to actually look at the .sql file I imported and saw this.
It drops my current table and replaces it with the old one. WHAT KIND OF FLOP BACKUP. I’m so disappointed in you, WordPress 2.0. I checked my tables and confirmed my fear. Six months worth of entries was completely gone on top of my blog not working at all. And since I didn’t freaking back up, there was nothing I else could do. I panicked big time.
In desperation, I messaged my host and asked if they have any backups for me. Fortunately, they did. It took half a day, but they restored their latest backup for me. I lost any comments I received in the past 48 or so hours, and my previous entry was also gone. At the very least, I managed to restore my previous entry from Feedly if you ever want to know a little something about my new theme. I can’t do anything about the comments though.
I’m super grateful to my host A Small Orange for working with me when I sent them a frantic support ticket at 11 in the evening. I know it was all my fault, but they were very patient and helpful. Also a special thanks to Michael for calming me down through this whole thing. I’m not gonna lie you guys. I cried.
As for my old archives, I won’t be trying again for a while.
Let this be a cautionary tale before you start messing with your databases: BACK YOUR SHIT UP.