WP Multisite to single WordPress manual installation

This post was made after a very intense session of 6 hours trying, without luck, to export a wp multisite site using the WordPress tools and plugins. So I decided to do it manually like a real man.

Well, now follow the steps below to extract a subsite from a Multisite Installation:

1 – Identifying the wp multisite’s subsite

1. Go to your WordPress network admin dashboard (https://example.com/wp-admin/network).
2. Go to ‘Sites‘.
3. Click in the site you want to export.
4. See the URL in your browser (https://example.com/wp-admin/network/site-info.php?id=3).

The site ID is 3.

2 – Export the wp multisite database

1. Install the plugin ‘Adminer‘.
2. Go to ‘Tools » Adminer‘.
3. Click in ‘Start Adminer inside‘.
4. Go to ‘Export‘.
5. Deselect all the tables and select only the ones starting with ‘wp_3_‘.
6. Select ‘wp_usermeta‘ and ‘wp_users‘.
7. Click in the button ‘Export‘.

3 – Edit the *.sql file

1. Open the downloaded sql file with your favourite code editor.
2. Find and replace ‘/uploads/sites/3/‘ with ‘/uploads/‘.
3. Find and replace the URL of the old subsite with the new URL for the single site.
4. If you think you need to find and replace something else to fit your new installation, this is the moment.

4 – Upload the *.sql file

1. Create a new database in your server as usual for a new WordPress site.
2. Import the modified sql of the last stage.
3. Perform this SQL Query » https://gist.github.com/rouralberto/b1278bcc1a3c012145d30d2e97ed8756

5 – Prepare the file structure for the new site

1. Download and copy the files for a new WordPress installation.
2. Copy all the plugins and themes folders from the Multisite to the new site.
3. Copy ‘/media/sites/3‘ to ‘/wp-content/uploads‘ in the new site.

6 – Et voilà!

1. Enter in your new site dashboard and check everything works good.
2. Finished!