---
title: WordPress Multisite to Single Site Extraction
url: "https://pressable.com/knowledgebase/extracting-a-single-site-from-a-multisite/"
published: 2021-04-22
modified: 2025-09-11
author: Wayne McWilliams
---

In the following article, we will go through the steps required to extract a WordPress multisite to a single site instance so that it runs independently from the network. Once separated, this site will have its own WordPress install and will count as a separate site on your Pressable account.

 
 Important:  Help with this is outside the scope of [Pressable’s Support Policy](https://pressable.com/legal/support-policy/), which is why we made this document. Our hope is this helps guide you to complete the steps on your own, or hire a developer to follow these steps for you.

## Step 1: Clone The Multisite

Your first step will be to clone the existing multisite by following our guide on [how to clone your website to staging](https://pressable.com/knowledgebase/how-to-clone-website-to-staging/).

## Step 2: Find blog ID and table prefix from phpMyAdmin

Next, you need to [log into phpMyAdmin](https://pressable.com/knowledgebase/access-phpmyadmin-with-wordpress/) for this (clone) website. We need to make a note of the table prefix used by this site, as well as make a few updates to the overall database structure.

Let’s pretend we need to extract “site2” from this install.

First, navigate to the wp\_blogs table. From there you can see the blog ID to the left of the site name. In this case, our blog ID is 4.

![](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/multisite-phpmyadmin.jpg?ssl=1)

You can verify this by selecting the \_options table for that ID. For our site, we can see from wp\_4\_options that all wp\_4\_ tables are used by “site2”.

![](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/multisite-database-tables-scaled.jpg?ssl=1)## Step 3: Update wp-users and wp-usermeta

You will need to edit the prefix of two tables in the database: **wp\_users** and **wp\_usermeta**. These table names need to match the prefix of the site being extracted. In our case, they will need to be changed to wp\_4\_users and wp\_4\_usermeta.

To edit the table prefix, click on the table name, then move to the Operations tab. You can change the prefix in the “Rename table to” field.

![](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/multsite-rename-database-tables.png?ssl=1)## Step 4: Edit the wp-config.php File

The next step is to connect to this freshly cloned website [via SFTP](https://pressable.com/knowledgebase/setup-and-use-sftp-to-connect-to-your-wordpress-site/) and open the wp-config.php file. You will need to remove or comment out the section related to the multisite configuration.

Here is an example of how that looks:
![](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/multisite-wp-config.png?ssl=1)

Here is an example of it commented out:
![](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/multisite-wp-config-remove.png?ssl=1)

You will then need to change the database table prefix to match that of the site being extracted.

![](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/multisite-config-prefix.png?resize=1178%2C330&ssl=1)

Once done, you can save the changes and upload the file back to the server.

## Step 5: Move the Media

You will need to move the media files [through SFTP](https://pressable.com/knowledgebase/setup-and-use-sftp-to-connect-to-your-wordpress-site/). With multisites, the uploads for each site are stored in their own unique folder. Those files should be moved to the root of the uploads directory, in the same way that other single WordPress installations function. You will find those files in /wp-content/uploads/sites/{{site-id}}.

![Switching from WP multisite to single site in the media files](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/multisites-media-uploads.png?resize=554%2C297&ssl=1)## Step 6: Search and Replace

Finally, run a search-and-replace on your site using a tool such as [Better Search and Replace](https://wordpress.org/plugins/better-search-replace/).

**Make sure you [take a database backup](https://pressable.com/knowledgebase/how-to-manually-back-up-your-site/) beforehand.**

You will want to perform a search and replace for:

- **multisite-url.com** to **singlesite-url.com**
- **uploads/sites/{{site\_id}}/** to **uploads/**

---

### That’s it!

Congratulations – you have split a single site out of a multisite instance.

Once you have verified that everything on the frontend and backend of the site is as expected, you can proceed to delete the site from the multisite network. To remove a subsite from the network, go to Network Admin > Sites. Under the site that you wish to remove click the Delete link.

![](https://i0.wp.com/pressable.com/wp-content/uploads/2021/04/subsite-delete-multisite.png?resize=300%2C119&ssl=1)