April 23, 2004
Well, that was a PITA

Ok, moving from a "conventional" movable type installation to a "MySQL" MT installation is officially now a major hairy pain in the ass. What follows will make sense only to those relatively fluent in the SQL database language. Those who are not: in my experience, there is a significant bug in the import process to do this conversion. I was importing entries at about 100 per pass. Each pass required zortching the successful entries, and re-uploading the rest. Each upload took about 4 minutes. Big deal you say? We got 10000 entries and comments!

How I solved it is below...

PS... email this entry is still broken... working on it...

MT-Entries has the mt-entry-author field set not to allow NULL. This is normally a Very Good Thing, as nulls cause all sorts of headaches when running queries. Unfortunately, it would appear that a bug causes the import process to hand a NULL value in this field to this table, on irregular occasion. For the life of me I could not figure out where or why, and I'm sorry pouring through a 10k entry dbase backup looking for a single null is beyond my abilities (and probably wordpad & notepad's too). Those of you with shell access and the ability to run regexes through bash or whatever will probably smirk, but I did what I had to do.

At any rate, by changing the mt-entry-author field to allow nulls, everything imported just peachy. When I was done, I ended up with, oh, two dozen or so bizzare entries in the STORIES area, and a whole bunch of errors besides. Zapping these fixed everything, and now it all seems (seems) to be working fine.

So props to Hosting Matters for giving me the ability to directly tinker with mySql databases. Otherwise I'd've been here all frikkin night.

Anyone else wants to do this I'm happy to help, but you'll owe me a case of beer in the morning!

Posted by scott at April 23, 2004 09:00 PM

eMail this entry!

Actually, I was giggling not smirking.

Posted by: Cindy on April 23, 2004 09:39 PM

testing a comment

Posted by: scott on April 24, 2004 01:55 AM

another test

Posted by: scott on April 24, 2004 08:31 AM

why did you change? I thought you LOVED Logjammer...

Posted by: Jim S on April 25, 2004 11:35 PM

Part of it was the whole vampire hunter thing... I didn't like that we were subject to British libel law. But most of it was economics. LJ is a really great place for small sites, but they're more expensive than HM once you're transferring more than 1 GB/month.

Posted by: Scott on April 26, 2004 07:58 AM
Post a comment

Email Address:



Remember info?