Stupidity Support

Thursday August 31, 2006 at 5:20pm website, being stupid, tech support Comments (0) »

As some of you already know, I have begun work on the next version of this Website (yes, please be sure my ghost has plenty of pepsi). In the course of writing a script to export my blog from the current db and import it into a slightly different format, I accidentally emptied the db table. The source table. I had completely erased my entire blog. Crap.

Kevin suggested I try some things to try to recover the data, and I found some stuff online about bin logs, but sadly, i don't know what i'm doing. Nor do I actually know if my hoster gives me sufficient permissions to do it anyway.

After about 2 hours of mucking about, I decided I couldn't pull it off. I submitted a support ticket to ICDSoft's support service. Within 23 minutes of my submission, my database table had been restored.

This has shown me two things, both of which I already knew from previous experiences:

1) For the sake of pete and his dragon, pay more attention to what you're doing.

2) The support my host provides is amazing.

Well, I'm off to backup my db before I try messing with it some more.