I've been working on upgrading my old existing WordPress installation to WPMU. I've documented the experience into what should be a pretty accurate guide to doing so in hopes that it may be of some use to someone else.
Before I apply these changes to my live site and claim this is accurate, I was hoping I could get someone to review my guide and tell provide any input. One point I'd like some help with is the non-breaking space issue (see step 5), in which the dump is replacing non-breaking spaces with an odd ascii character. Thanks!
Edit: Turns out I can't login to the new site either. I'm not 100% certain whether this has anything to do with the fact that I'm running the test on a different URL.
And here it is:
--------------------------------------
Upgrade WordPress to Wordpress MU
This is a quick draft for what I've done to install a new WPMU installation
TO THE SAME location as my old existing WP installation. eg, my old blog,
which was at http://www.hawkeye411.com will still be there and users shouldn't
see any change. New blogs will be located at *.hawkeye411.com
(basketball.hawkeye411.com, wrestling.hawkeye411.com, etc).
This guide assumes you have a fairly good knowledge of SQL. I'm using
phpmyadmin to make everything a bit easier. I'm writing it as I do a test
upgrade of my blog, so its a guide more for me than anyone else, but I
thought some other people might find it useful so I've cleaned it up a bit.
This document is provided without any implied guarantees. If you have
questions, contact Jared on http://www.hawkeye411.com.
1) Create fresh WPMU install following its install instructions
2) Contact host to set up wildcard dns (*.site.com)
3) Upload theme to new MU installation (if applicable)
4) In phpmyadmin, export the database from existing WP installation. Make
sure you have following options checked:
Structure
Add DROP TABLE / DROP VIEW
Save the dump as a file without compression.
5) Find and replace table names in the database dump:
Existing line: INSERT INTO 'wp_
Replace with: INSERT INTO 'wp_1_
Existing line: DROP TABLE IF EXISTS `wp_
Replace with: DROP TABLE IF EXISTS `wp_1_
Existing line: CREATE TABLE IF NOT EXISTS `wp_
Replace with: CREATE TABLE IF NOT EXISTS `wp_1_
For whatever reason, non-breaking spaces were screwing up in my exports:
Existing text: Â
Replace with:
6) Change common WPMU table names back for shared tables, making sure to
change the table names in the drop, create and insert blocks. These tables should
appear at the end of your dump:
wp_users
wp_usermeta
7) Run SQL from original WP database dump
8) Double check everything you can think of -- you should be good to go