How to Migrate a WordPress Multisite Subsite to a Single Site
WordPress Multisite is an efficient way of connecting multiple websites and managing them from one central location. In fact, integrating several websites into one WordPress install offers website owners many benefits.
But what would you do if a single website outgrew your multisite network?
Today we are going to take a potentially difficult scenario – migrating a WordPress multisite subsite to a single site – and make it a little simpler. We will look at what multisite is, the benefits of using it, and two ways to split a multisite network into singe sites so that you can give your growing sites room to grow and garner more success.
What is WordPress Multisite?
A multisite network is as a group of websites that all share the same WordPress installation. Each website then separates into either subdomains or subdirectories and is easily accessed using your chosen multisite network structure or by domain mapping individual URLs with a few additional steps.
With a multisite network, you access all of your interconnected websites from one easy drop-down menu in the WordPress admin area, thus making the management of your websites easier. In addition, you can share all of your installed plugins and themes across the many websites you have in the multisite network. Furthermore, you can specify which ones to utilize on which websites.
In the end, setting up a multisite network gives you more control, saves you time, and gives you instant access to all of your websites by logging in one single time.
Migrate a WordPress Multisite to a Single Site Using WordPress Functions
There may be times when you want to migrate a multisite subsite to a single site install. These steps will outline how to do just that using the default WordPress functions, all of which are included in every WordPress install.
Step 1: Make a Backup
Before beginning the process of the exporting a single website from your multisite network, you must back everything up. Since exporting a website can be a difficult and often time-consuming process, you want to protect your site’s data from power failures, web-host server crashes, and even hack attacks.
So, make a thorough backup of your entire multisite installation and make sure to save it in an offsite area you can access should anything go wrong during the migration.
Step 2: Export the Single Site from the Multisite Network
The great thing about WordPress is that it has a built-in import/export functionality that can be used on both single site installs and multisite ones.
To utilize this feature, first log in to the WordPress dashboard of the single site you would like to migrate away from your multisite network. Next, navigate to Tools > Export.
Make sure that you select All Content and then click on the Download Export File button. After doing this, WordPress will create an XML file that has all of your data included and send it to your browser for download. Save this file to your computer for later use.
Step 3: Install WordPress
The next step after exporting all of your website’s data is to create a separate install of WordPress for your newly single website. Check here for a secure way to do just that.
Step 4: Import Site to New Domain
After successfully installing a fresh WordPress install for your website, log in to the WordPress admin section of that new install. Here you will import your exported website data (you know, the file you saved to your computer for later use). To do this, navigate to Tools > Import and select the WordPress option.
Additionally, WordPress will ask you to configure the following:
- Import Users. Unless you want to change authors on your newly single website, it is recommended you do nothing and allow WordPress to import all existing users.
- Import Attachments. Check this so that WordPress can import all images from the posts and pages of your website as they were in your multisite network.
WordPress will then import all of your single website’s content into the new single site install. Keep in mind this may take several minutes depending on the size of your website. When everything has successfully imported, you will see an “All done, Have fun” notification.
And that’s it. You have now migrated a multisite subsite to a new single website using the default WordPress features.
But, there is another way…
Migrate a WordPress Multisite to a Single Site Using WP Migrate DB Pro
WP Migrate DB Pro is a premium WordPress plugin that offers website owners a whole host of features:
- Push and pull databases for improved workflow
- Detect serialized data and run a special find and replace to ensure there is no corrupted data
- Backup your database before replacement with one-click
- Start, pause, and resume your site migrations for ultimate control
- Work in temporary tables so your live site is never affected
- Track migration process with visual progress bar
- Enjoy multiple add-ons such as the Multisite Tools Addon for exporting a multisite subsite to a single site
As you can see, WP Migrate DB Pro makes migrating websites very easy. And, it provides security and protection of your website data so that nothing becomes corrupt or lost.
In addition, the Multisite Tools Addon, which is what we will be discussing today, lets you push migrations from a multisite install to a single install of WordPress. Let’s see how that works.
Step 1: Export Website Files
After purchasing, installing, and activating the WP Migrate DB Pro plugin, you will be ready to begin extracting your subsite and pushing it to an already installed single site. Keep in mind that the Multisite Tools Addon comes included with the Developer, Studio, and Agency plans.
Navigate to Migrate DB Pro in your WordPress dashboard. You will then see a screen with several migration options. Click on Export File and both checkboxes to save your files to your computer as well as compress the file with gzip.
Since the creators of WP Migrate DB Pro are always improving the functionality of their plugin, you will notice a checkbox labeled Export a subsite as a single site install. This is a new feature that makes migrating a subsite that much more intuitive.
From the dropdown menu, choose which multisite subsite you wish to migrate to a single site. Next, change the New Table Name Prefix to match that of the table name your single site install will use.
For instance, you might rename it subsite_. You will then change the URL in the next textbox to reflect the New Table Name Prefix. In our example, this would be //subsite.dev. In addition, rename the path.
The Tables box will only show you the tables that belong to your selected multisite subsite, as well as the usermeta and users tables that all subsites use. You can export all of them or choose those unique to the multisite subsite you are exporting.
You also have the option to include your multisite subsite’s media in your migration under the configuration labeled Media Files.
When these steps are complete, you can save the migration by giving it a unique title. Then, click on Migrate and Save Profile. WP Migrate DB Pro will immediately begin exporting your multisite subsite data as a newly created SQL file.
Step 2: Import the SQL file
The developers of WP Migrate DB Pro then suggest you import the newly created SQL file using your preferred MySQL administration tools. These may include phpMyAdmin, Sequel Pro, or the CLI Addon that comes with WP Migrate DB Pro Developer, Studio, and Agency plans.
For a closer look at how to do this, check out WP Migrate DB Pro’s quick migration video:
After importing the SQL file to your fresh WordPress install, simply refresh the site and voila. Your multisite subsite should appear with all of its content and media.
Migrating multisite subsites to single site installs can be a complicated process, especially for those that are relatively new to multisite functionality. However, the wonderful thing about WordPress is that there are typically multiple avenues to choose from when it comes to accomplishing any task, site migrations included.
If you are one that prefers to work within the WordPress admin itself and utilize the default tools WordPress kindly provides all website owners, migrating a subsite is doable. There are however increased risks of corruption, mistakes, and time-consuming steps when choosing to go the default way. Unfortunately, this is true with many built-in WordPress features. Despite its best intentions, using WordPress to perform complicated tasks is not always the best option.
If however, you want things to be extremely simple, more secure, and less involved, I recommend trying WP Migrate DB Pro. Not only does this plugin allow you to push and pull sites between multisite networks with a few clicks, it provides you tons of other useful features that multisite website owners like yourself will be interested in.
Have you ever migrated a multisite subsite to a single site install? What method did you use? I would love to hear all about it in the comments below!