Help articles General Questions

How do I go live on Flywheel with a Multisite?

Note

Going live with a multisite involves editing the site’s database. We strongly recommend backing up your site before going through this process, as there isn’t any way to undo database changes.

To go live with your site on Flywheel, you’ll need to complete these steps:

1

Turn Privacy Mode Off


Remove the 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 ‘overview’ tab for your site, in the lower-right of the dashboard.
browser_password

 

2

Add domains


Add any and all domains you will be pointing at your site to the domain list on the site’s page in Flywheel. This includes www.example.com and example.com.

If your multisite is a subdomain multisite, you’ll probably want to add the wildcard domain, *.example.com as well. This will cover any and all subdomains that may need to be directed to your site.
browser_adddomain

Add a new domain

 

3

Set primary


Set the appropriate domain to primary. This will update your site’s database to use the correct domain.

 

browser_primarydomain

Note

For this next step, we’re assuming your SQL table prefix is “wp_”. If you’re using a different table prefix, replace “wp_” in the following table names with your prefix)
4

Update Multisite database

 

The easiest way to do this is to head to wpmultisitedomainreplace.com, enter the proper information about your site (database prefix, number of subsites, old domain and new domain), then hit the “Generate SQL!” button.

That will give you an SQL command, which you can copy and then run on your site’s database to make all the necessary replacements automatically.

To do that, copy the SQL command you get from wpmultisitedomainreplace.com, then head to your site’s Flywheel dashboard. Click “manage” under the Advanced tab to access the database manager, then click the “SQL” tab, and paste the SQL command you got from wpmultisitedomainreplace.com into the SQL command box. Finally, hit the “Execute” 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 at wpmultisitedomainreplace.com.

 

If that worked, you can skip to the next step! If not, or if you’d prefer to make the updates manually, follow these instructions:

 

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_site
  • wp_sitemeta: the row named “siteurl”
  • wp_blogs: any entries in the “domains” column that have the
    Flywheel Temporary domain name
  • wp_#_options: update “siteurl” and “home” corresponding to blog id

Note

You’ll notice the ‘#‘ 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.
5

Point domain DNS


Point your domains at 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, and Bluehost.


  • Organizations

    Everything you need to know about managing your team with our Organizations feature.

    8 Articles
  • Blueprints

    Learn everything there is to know about what Blueprints are, how to create them and how to make the best use of them.

    5 Articles
  • Simple SSL

    All there is to know about our free, automatically installed and activated SSL certificates.

    8 Articles
  • Staging

    How to get the most out of Staging, which allows you to duplicate a site, make changes, and then push those changes to the live site.

    6 Articles
  • Local by Flywheel

    Everything you need to know about our amazing, free local WordPress development software for Mac and PC.

    5 Articles
  • White Label

    Everything you need to know about our Whitelabel subscriptions for branding and reselling Flywheel.

    4 Articles
  • Getting started

    Everything you need to know to get your first Flywheel site up and running.

    8 Articles
  • Frequently Asked

    The most commonly asked questions, and a few we just think you should know.

    24 Articles
  • General Questions

    Questions that don't fit elsewhere, or those about Flywheel in general.

    56 Articles
  • Billing & Accounts

    Questions relating to payments, billing and managing your account on Flywheel.

    12 Articles
  • Domain Names

    Details about how to manage DNS and point your domain names at Flywheel.

    10 Articles
  • Database

    How to access your WordPress database to make changes and update content.

    3 Articles
  • Security

    Details about everything Flywheel does to makes your site so secure.

    12 Articles
  • Plugins

    Which plugins work best, which plugins work worst, and everything in between.

    7 Articles

Get in touch with us

Standard support hours are M-F 9am-5pm CDT and 24/7 emergency support.

WordPress experts

Try it yourself. It's free & takes less than 60 seconds. Sign up

× How to manage 50+ WordPress Sites

Here's a free ebook!

How to manage 50+ WordPress Sites