Our next major release of WP Migrate DB Pro will introduce a new addon: Multisite Tools.
One of the most popular pages in our documentation for WP Migrate DB Pro is the tutorial for Extracting a Subsite From Multisite to Create a New Single Site Install. The first version of the Multisite Tools addon has been specifically built to make this process even easier.
When installed and activated in a Multisite install of WordPress, the new Multisite Tools addon adds a couple of very useful options to Export migrations: Subsite Selection and Table Name Prefix.
When you check the “Export a subsite as a single site install” checkbox you’ll get a select box to choose the subsite you want to export. When you change the selected subsite, the URL in the Find column of the Find & Replace rows changes to match, and the tables to be exported are updated to only show the tables for that subsite. This also includes the usermeta and users tables that are network wide.
By default the Table Name Prefix textbox is set to the base prefix for the network, but if your target single site install has a different prefix you can set it here. When the export runs the
CREATE TABLE statements in the SQL file, this prefix is used for the table names. For example, if the network’s base prefix is “wp_”, and the table “wp_2_posts” is being exported for the subsite with ID 2, you would get the table name “aW350m_posts” if you specify prefix “aW350m_”.
Anyway, enough of the waffle, I’ve put together the following video to show the Multisite Tools addon in action.
Oh, and by the way, we’ve only shown exporting a subsite from a domain based Multisite Network in the video, but Multisite Tools works with path based Multisites just as well.
I hope you enjoyed this little preview of the first version of the Multisite Tools addon for WP Migrate DB Pro. We have big plans for the future of this addon, make sure to subscribe to our WP Migrate DB Pro mailing list to learn about future updates.