WordPress MU

I'm writing some scripts to import some 500+ blogs into MU from a WP installation and could use some help figuring out what to do with certain tables, please. The following per-blog tables are found in WP, but not in MU (I don't think these are plugin related):

*_categories
*_linkcategories
*_post2cat

The following per-blog tables are in MU but not in WP

wp_*_terms
wp_*_term_relationships
wp_*_term_taxonomy

I could use some help reconciling the differences. Thanks.

First you need to upgrade to the latest WP. The WP tables you mention haven't been used since before WP 2.3.

Hmmm... for some 500+ single WP installs, I'd almost want to try an earlier version of MU, get the WP blogs into that, then upgrade MU.

Thoughts?

lunabyte, thanks. i was going to upgrade before i did the import, but didn't realize there were database upgrades. i just inherited this system and haven't run upgrades. i hope i can run upgrades on all of the separate WP installations at once.

andrea_r, for what reason? because the db schema will be more similar? what version of MU would you recommend to correspond to WP 2.0.4?

thanks.

"i hope i can run upgrades on all of the separate WP installations at once."

Probably not. Which I why I suggested what I did. :) unless you've already got a pre-exisiting script to upgrade them all.

If you have to do it manual, then I'd just get them all into MU first. The numbers weren't synched up back that far, but you might be okay with a version of MU that is not so far behind. like 1.2.5 maybe? I'd have to go check and see, but that sunds right. 1.2.4 should be okay.

WP 2.0.4? Wow, talk about a hacker's wet dream.

Being that far behind, there isn't going to be an easy way to do it.

Data integrity is going to be the key issue, as there were tons of changes since then.

You could try working with a 1.0 version of MU, which (should) be about WP 2.0. Then upgrading through the MU 1.1.x, 1.2.x, 1.3.x, and finally up to 1.5.1.

I'd recommend mimicking the live domain locally (through the hosts file), and doing it local. That way, while working with such old versions, there shouldn't be a risk of someone finding and then exploiting your site.

Thanks lunabyte. I'm going to work with 1.0. I noticed two release candidates for 1.0. Do you think rc3 or rc4 will make a difference? Thanks.

I started working with 1.0 rc4 and noticed the following discrepancies still in the schemas:

*_catgories tables has three fields in MU 1.0 that are not in WP 2.0.4: link_count, posts_private, & links_private

*_link2cat table is in MU 1.0, but not WP 2.0.4.

*_linkcategories table is in WP 2.0.4, but not MU 1.0.

I'm guessing the first two issues listed above will not be a huge issue because there will be no loss of data since the MU schema has more. I'm not totally against depriving my users of some small feature or data if the blogs on the whole will work and any deprived functionality at least works in the future once I'm upgraded.

I'm particularly worried about the last one, the linkcategories table, since there will be complete data loss if I don't find out where to put this table.

Thanks again.

bump.

In addition to bumping my previous question, above, I was wondering how to generate the value for the wp_*_autosave_draft_ids value in the wp_usermeta table. Thank you.