« Shibboleth Deployment | Main | Pete's Weblog Moved from Old Machine and Upgraded to MT 3.0 »
June 28, 2004
Convert MT Data from BDB to MySQL, Dump on Old and Restore on New Machine
Got access to the old server (Pete had blocked almost everything via ipchains). Thought I'd better take a crack at getting my old data over to the new machine before I had too many entries. To make things complicated we're blocking all web traffic and the entries on the old weblog are in BDB.
I decided I really didn't want to copy all the tables . . . just the entries and comments (including some spam that I hadn't caught).
On old server:
- Edit mt.cfg, adding config for MySQL database
- Run mt-db2sql.cgi via a wget request
- mysqldump from mt_entry and mt_comment where blog_id=
On new machine
- Dump few entries I'd made in the new weblog
- Delete records from mt_entry (so old entries coming over from previous weblog could keep ids)
- Use new MT to set up blogs and categories
- Import mt_entry data
- Run a few mysql updates to change blog_id
- Manually change ids for the dumpfile I'd created of new entries and reimport
Either I didn't do something right, or there was a problem with the BDB conversion, none of hte old entries have categories on the new weblog. Any bets on whether I ever go back and update them? Probably not until after I get the energy to make the style tweaks.
Sometimes a fresh start can be good, but most often it's just a lot of work.
Posted by mike at June 28, 2004 4:05 PM
Hard Drive Recovery Group offers hard disk data recovery services for RAID, laptops and servers. Complete clean room and hard drive repair service.Trackback Pings
TrackBack URL for this entry:
http://mike.kruckenberg.com/mt/mt-tb.cgi/9
Comments
your blog entries are probably pointing to unknown category id's which are in the mt_category table. you'd also want to grab the mt_placement table. both tables have a "blog_id" you can key off of.
you might also consider grabbing the the trackback and tbping table entries that match your blog_id.
have fun.
Posted by: ac at June 28, 2004 5:52 PM
The category_ids are NULL in mysql. If they were the wrong number I could do some careful updating to make them match, but they are all null, null, null.
Posted by: Michael Kruckenberg at June 28, 2004 8:29 PM