hey,
i have this complex migration i'm in the middle of. i'm moving an mt3 blog to an already active mt4 blog.
on this mt4 blog, I've backed up the mttemplate table for blogid 10, and I'm restoring a blog into mt4 that I want to have the same blog_id of 10, so that I can restore the template table.
i've deleted the old blog_id 10 blog, but restore kicks me to 13 (which is the next free number).
How do I:
A: Have it restore right into blog_id 10
or
B: Change a blog from one ID to another.
I'm guessing this would be a mysql query - so if someone can help me with that I'd be happy to execute.
Thanks!
Neil
A. See here
B. Scary. Very scary. You have update mt_blog.blog_id and every single instance of OBJECT_blog_id (where object is like entry, comment, objecttag, etc) in each of the tables and then simultaneously update them all to your desired ID. Not for the faint of heart...