WordPress MU

I'm trying to migrate around 500 blogs from a WP 2.0.4 installation scattered over multiple databases to a single MU 1.5.1 installation. I will upgrade WP to 2.5.1 before I do this and MU 1.5.1 is already installed and working with a fresh installation. I am pretty handy with scripts and have "full access" to the servers with regards to file system and network access so moving files and opening SQL connections won't be a big deal.

I've searched the forums and found a lot on the topic of migrating WP blogs to MU, but they all seem to involve moving an insignificant number of blogs using methods that require unscriptable tasks for each blog like using the export plugin, resigning up for each blog or user. The best post I've found seems to be going in the right direction, but in the end the directions for the migration only include a single blog, I think.

Adapting the instructions from the link above, I believe I can script the process of going through all of the blog tables in all of my WP databases and getting them into the MU database with the incrementing table prefixes, i.e. wp_1_*, wp_2_*, etc., but I'm not sure if I need to also add entries for the wp_blogs table or something for each blog to make MU aware of all the blogs. I'm also not clear on how to migrate the users over with their permissions for each blog maintained.

Your help is greatly appreciated. Thank you.

As far as I know this doesn't exist in script form.

Your best bet would be to set up MU somewhere, add a couple test users & blogs, then study the database.

I'm going to write the scripts. I looked at the database schema and had some questions and need some affirmation on the assumptions I made. I am looking for insight into the database and how best to move from one database schema to the next.