As you know, I’ve been struggling with rebuilding my blog from the .frm, .MYD and .MYI files for the past few days (since I moved my hosting services). I managed to get the posts recovered up until Jan 2007 but then I hit a brick wall. Every time I attempted to recover more, the system boo’d and hissed at me and barfed back a series of error messages. My new host wouldn’t let me drop the original files into the data folder – where the SQL dbase is installed – so I desperately needed help to recover the last 5 months of posts.

Enter the best friend a strung out blogger can have – Clayton. I’ve know Clayton since we took a class together at college in 1998 and shortly after graduation he started working for the same company I was collecting a paycheque with. We’ve worked on many of the same projects and teams and he’s one of the most knowledgable technical guys I’ve met. Add to that his sweet disposition and it makes for a hell of a great guy (are you listening ladies?)

Fed up with struggling with recovering my blog, I found Clayton on-line tonight and explained what I was trying to do. I shipped the files to him et voila, he was able to recover all of my previous posts from the database. He hung around long enough (over 3 hours in total) until we were sure everything was appearing on the site. I don’t know many people who’d give up a big chunk of their Friday night to help a friend recover their blog, but I’m really glad that I do know Clayton.

Clayton, as always – you rock!

End result:

• Lost posts = 0
• Lost comments = 3 (the ones people made while I was attempting to recover my blog)
• Crappy former host = -10.0 (not only did they refuse to help, take days to respond to my email requests for assistance, but they have yet to release my domain to the new host). I can’t cancel my service with them until I’m sure my domain transfer is complete, so I’m stuck paying for an extra month’s service due to their slow response.
• New host = 0.5 (they had no idea what I was talking about when I approached them for help – Clayton understood what I was trying to do in less than a minute.)
• Clayton = 10.0

We can start the celebration immediately.

Note: I’m leaving this post up as a sticky post for a few days because Clayton deserves to be recognized. Scroll down for posts dated after Friday, June 15 2007.

Technorati Tags: friends, domain, host, sql, database

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.