Caveat Lector

Well, that was fun, for values of “fun” that mean “no fun at all, really.”

I got all the other yarinareth.net blogs up and running in a jiffy. No sweat. WordPress export, WordPress import, ba-da-bing ba-da-blog. (Li, I can’t remember what the name of your theme was. If you remember, let me know… or feel free to dig up a new theme.)

CavLec? Was a problem. I couldn’t use the WP export, because CavLec is so gargantuan the export command timed out, and I couldn’t convince OldWebHost to help me make it work. So okay, I did the SQL dump, checked it, and lit out for greener pastures.

It’s supposed to be easy to restore a blog from a SQL dump. Change the table names to fit WPMU, import, done. Except not so much. Go to blog, get white screen sans error messages. Well, that’s just great.

After contemplating my rock collection, I picked up the bit-at-a-time SQL rock, playing only with the tables I knew I would need. I suspected the issue was that the wp_options table from the old blog was playing hob with WPMU.

Well, I was wrong, but the tactic did enable me to figure out what the problem was… the wp_posts table in WPMU was missing two fields (post_lat and post_lon, and why I need to geolocate my posts I’m sure I’m not sure) that the SQL dump had. So okay, I add the fields to the table, cut-and-paste the INSERT clauses just to be safe, and what do you know, I seem to have a blog again.

There are issues. Image links from this blog (and all Yarinareth blogs) are umpty-broken. I have the images and will fix when I can. But for now, I’m just happy to have my BLOG BACK.