I have run into the situation where I needed to transfer a WordPress Multisite twice now, My first experience was horrific, but it seems I have a better handle on this now.
Step 1: Back everything up
Should be pretty self-explanatory — back up your files and database in preparation to transfer. DO NOT copy the
wp-config.php files, it’s better practice to set these up from scratch.
Step 2: Copy the files to your new server/location
Send over your files to the new location via FTP, SSH, SVN, whatever. Create your database and set up your
Step 3: Go through WordPress installation
Before you import your database, go through the steps to set up the WP site from a clean install. Go through the steps to setting up a WPMU. This way the code you need to stick into your
wp-config.php files will have the proper rewrite rules, as well as
Step 4: Import your database
How that you have the vanilla WordPress Multisite install set up, go ahead and import your database into it’s new location. Now that we have the database imported, it’s time to alter some tables.
Step 5: Go into the database tables
Give into the following tables, and seek out your old domain. Replace all existing records of
wp_blogs – this holds record of all your WPMU blogs. Alter the
wp_options – here do the normal alterations from home_url and site_url, as if you were transferring a regular WordPress website. If you have multiple blogs, you will need to go into wp_2_options, wp-3_options, etc.
wp_site – This defines the multisite domain and path. Change the domain here.
wp_sitemeta – Search for the meta key
siteurl – change the domain.
wp_usermeta – Search for the meta key
source_domain – change the domain.
Once you have completed this steps, you’re all set! Leave comments below if you experience any issues!