When you’re ready to take your Multisite live on Flywheel, complete the following steps:
Since the database will be edited as part of this process, it’s a good idea to back up your site in case you need to revert.
Disable Privacy Mode for your site on Flywheel, so that it’s visible to visitors and search engines. You can turn Privacy Mode off from the site’s Overview tab on the right sidebar.
Add any domains (and subdomains) you will be pointing at your site to the Domains card.
www version of the domain will be added (uncheck the box to skip this step)
If you haven’t yet, set the appropriate domain to primary by clicking the 3-dot menu and choosing Make Primary. This will update your site’s database to use the correct domain.
The easiest way to update the database is to head to the WordPress Multisite Domain Replacement Tool and enter the proper information about your site (old and new domain, database prefix, number of subsites).
That will give you an SQL statement, which you can copy and then run on your site’s database to make all the necessary replacements automatically.
As with any modifications to the database, it’s strongly recommended to create a backup before proceeding any further.
To perform the database update, copy the SQL statement you received, then head to your site’s Flywheel dashboard.
Click “Manage Database” under the Advanced tab to access the database manager, then click the “SQL” tab, and paste the SQL into the SQL query box.
Finally, click the “Run SQL” button just below it.
You should see several success messages, and possibly some errors. That’s normal. As long as you’re seeing at least some success messages, you’re good. If not, double-check the info you entered just to make sure everything’s correct.
If that worked, you can skip to the next step! If not, or if you’d prefer to make the updates manually, follow the instructions below.
Login to your database manager from your Flywheel Dashboard and then edit the following tables from your Flywheel Temporary Domain to your new Primary Domain:
wp_options: rows named “siteurl” and “home”
wp_sitemeta: the row named “siteurl”
wp_blogs: any entries in the “domains” column that have the
wp_#_options: update “siteurl” and “home” corresponding to blog id
#‘ in the step above when referencing
wp_#_options. Each sub-site will have sets of tables that correspond to the
blog_id in the
wp_blogs table. You’ll need to go to the
wp_#_options table, where ‘
#‘ corresponds to the blog_id, and update the “siteurl” and “home” rows in that table.
Point your domains to the site’s IP address (found under the domain list in Flywheel). For more information on how to point DNS at your site, visit our help article on setting up DNS. We also have registrar-specific articles for setting DNS on GoDaddy, MediaTemple, Hover, Namecheap, Bluehost, and more.
If you have any questions our Happiness Engineers are here to help!
New to Flywheel? Start here, we've got all the information you'll need to get started and launch your first site!View all
Learn all about managing your Flywheel user account, Teams and integrations.View all
Everything about billing, invoices and payments can be found here.View all
Flywheel hosting plans include a ton of great features. Learn about how to get a free SSL certificate, set up a staging site, and more!View all
All the server and setting info you'll need to help you get the most out of your Flywheel hosting plan!View all
Tips and tricks for managing your sites on Flywheel, including going live, troubleshooting issues and migrating or cloning sites.View all
Learn how to connect, deploy, and more with SSH on Flywheel's platform.View all
Learn more about Growth Suite, our all-in-one solution for freelancers and agencies to grow more quickly and predictably.
Getting started with Growth Suite
Growth Suite: What are invoice statuses?
Growth Suite: What do client emails look like?
Learn more about Managed Plugin Updates, and how you can keep your sites up to date, and extra safe.
Managed Plugin Updates: Database upgrades
Managed Plugin Updates: Pause plugin updates
Managed Plugin Updates: Plugin Security Alerts