Migrating a Site out of Multisite Manually

Migrating a Site out of Multisite Manually

The site you’re moving out of Multisite will have three components that you need to copy from the Multisite network:

• theme and plugin files—you might copy these across or reinstall them in the new site
• uploads—you’ll find these in the site’s subdirectory in wp‑content/uploads/sites
• database tables—you don’t need all of the database tables but just the ones relating to this site

Note: If your Multisite network was created prior to WordPress 3.5, you won’t have a sites folder. Instead you’ll have a blogs.dir folder in wp-content with all of the upload files for the subsites. This will have a numbered folder for the site you’re migrating, which you copy instead. I’ll cover this in more detail below.

Do You Really Need to Move the Site?

Before you start, think about the reasons you’re migrating the site. Could it be purely to have a new domain name? If this is the case, then the free domain mapping plugin will let you give individual sites their own domain, and visitors will never see the domain of your Multisite network.

But if this isn’t the only reason, then read on!

Backing Up First

Before you do anything like this, it’s a good idea to back up your Multisite installation. Use your preferred backup plugin, or a combination of FTP and phpMyAdmin if you prefer to work manually.

You’ll use this backup to copy the relevant files to your new site, and it also gives you some peace of mind in case you have any problems.

Finding the ID of Your Site in the Multisite Network

Each site in a Multisite network has its own unique numerical ID. This is used to identify its folder in the wp-content/uploads/sites directory (or wp-content/blogs.dir if your Multisite network is older—see above), and also to identify the database tables for that site.

Find this by going to Network Admin > Sites and then selecting the Edit option for the site you’re working with. The URL WordPress takes you to will give you the site’s ID. The URL should be in the form http://mynetwork.com/wp-admin/network/site-info.php?id=XX.

XX is the ID of your site, and will be the name of the folder containing its files, as well as the prefix for its database table names.

Exporting the Site’s Tables From the Network

As you’re only moving one child site and not the whole installation, you won’t need the contents of your entire database.

In PhpMyAdmin, click on the Export tab. Then find the tables relating to the site you’re exporting. They will begin with wp_XX_, where XX is the ID of your site. An example is shown below.

Select all of the tables relating to your child site and then export them.

Note: WordPress Multisite stores all data relating to users of the network in the wp_users and wp_usermetatables: it doesn’t create separate ones for each site. If you have a lot of users on your site which you want to copy across from the network, then you might want to export those tables as well, import them to the new site and edit users in the admin screens to remove any that are not relevant to the new site. However, if your site just has one or two users, it’s easier to recreate them on the new site. For more information on Multisite and database tables, see this tutorial on the WordPress database and Multisite.

Editing the Database Tables

Make a copy of the sql file that’s been downloaded to your machine and give it a name that tells you what it is (for example by adding copy to its name). Open it in a code editor.

Editing Links

Change all instances of the site’s domain in the Multisite network to its new single site domain. For example if your site was at http://network.com/mysite, change it to to http://mysite.com. If your network uses subdomains, you’ll need to change all instances of http://mysite.network.com. If you do this I’d advise also running a check for the subdirectory version just in case. Save your file.

Note: If your site had a domain mapped to it which isn’t the domain you’re moving it to, you’ll need to replace that with the new domain too. Tread very carefully here, and keep backups!

Editing Table References

The database tables in your new single site installation won’t have prefixes for the site ID, so you’ll need to remove these. In your sql file, replace all instances of wp_XX_ with wp_, where XX is your site ID.

Now save the sql file.

Installing WordPress and Creating a Database in the New Location

In phpMyAdmin, create a new database in the location for your new site and install WordPress in the normal way.

Uploading Files to the New Site

Identify the plugins used by the child site and either install them in your new WordPress site via the Pluginsscreen or upload them from the backup you took of your old site.

Do the same for any themes your site is using—copy them from your backup to the wp-content/themesdirectory of your new standalone WordPress installation, or just reinstall them.

Copy the uploads from your old site to the new one:

• If the network was created after WordPress 3.5, it will have a sites folder in wp-content/uploads. Find the subfolder with your site’s ID and upload its contents to the wp-content/uploads folder in your new site.
• If the network is an older one and has a blogs.dir folder, that will also contain a folder with your site’s ID. That will then have a subfolder called files. Copy the contents of the files folder to the wp-content/uploads folder in your new site.

Note: you may need to delete any folders WordPress has created in your new uploads folder to avoid any clashes.

Once you’ve done all this, activate any themes and plugins.

Importing Tables to the New Database

Now that you’ve installed your themes and plugins, you need to import the database tables.

Dropping the Existing Tables

Before you upload the tables from your old site, you’ll need to delete the duplicate ones which WordPress has added to your new site.

In phpMyAdmin, drop the following tables from your database:

• wp_commentmeta
• wp_comments
• wp_links
• wp_options
• wp_postmeta
• wp_posts
• wp_terms
• wp_term_relationships
• wp_term_taxonomy

The screenshot shows my database with just those tables selected:

Select them, click on the With selected: dropdown box, and select Drop. When prompted, click Go.

Note: Don’t delete the wp_usermeta or wp_users tables, unless you’ve chosen to copy these across from the network as well (see above).

Uploading the Database Tables

Next upload the database you’ve edited:

• Click the Import tab.
• Click the Choose file button.
• Select the sql file you’ve edited and click Choose or OK.
• Click the Go button.
• After a while (depending on the size of your database), you will see a message telling you the upload has successfully finished.

Final Steps

Clear your browser’s cache. This avoids any problems you may have if the browser has cached content from the old site.

Now log in to the WordPress admin for the remote site. If you moved the user tables across, your login details will be the same as for your old site, but if you didn’t, these will be whatever you specified when you installed WordPress in the new location.

Visit the Permalinks screen and turn pretty permalinks back on.

Check that all your links are working ok and that widgets and plugins are behaving as they should. If not, you can either step back through the process, using your backups where you need to, or simply set up the plugins and widgets from within your new site.