All right, you’ve made your changes to staging, confirmed that everything’s running well and looking good, and you’re ready to go live with your shiny new edits. This is the exciting part, but it’s also a little tricky. Don’t worry, we’re here to help!
When you’re ready to push the changes from your Staging site to the live production site, start by clicking the “Move staging changes to live site” button in the Staging tab of the site’s Flywheel dashboard. Don’t fret – it won’t happen right away. First you’ll see this pop-up, giving you some options and asking for confirmation:
The “Copy staging database to production” checkbox is the most important (and maybe the most confusing), so we’ll go a little more in-depth on that here.
If you check this box, your live production site’s database will be completely overwritten with the staging site’s database. Otherwise, if you leave it unchecked, the database of the live production site will be left untouched and will retain all of its current data; only file changes will be copied from staging.
It can be a little tricky to understand the difference, so here’s a quick guide to what will happen in both cases:
|Copy staging database to production?||Result:|
|Yes (checked)||All of the above still happens, plus the staging database will overwrite the live production site’s database. The database includes: all posts, pages, post and page content and revisions, navigation menus, widgets, WordPress users, comments, configuration options, store data such as products and orders, and WordPress options.|
If the difference between what’s included in the site’s files and what’s included in the database is still a little confusing, maybe this will help: essentially, if it’s anything you could potentially save on your computer and/or access via FTP, it’s a file. Otherwise, if it’s something you click, check, select, or build within WordPress itself, it’s probably stored in the database. So a plugin itself is a file (or a collection of files), but the specific configuration options and settings for that plugin are stored in the database.
There’s no middle ground between overwriting the live production site’s database with staging and leaving it untouched. There is no way to simply merge the two databases automatically using staging at this time. There are, however, a number of plugins and tools available for this process, including WordPress’s built-in import/export feature.
WarningFor reasons named above, it is highly inadvisable to use staging to make any database changes at all on eCommerce sites, membership sites, or in any other situation where users may be adding or editing live site content while staging changes are being made. In these cases, we recommend that staging be used only for changes and updates to files, like plugins, themes, and uploads. More on the best way to use Staging and why can be found in this help doc.
Questions relating to payments, billing and managing your account on Flywheel.14 Articles
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
How to access your WordPress database to make changes and update content.3 Articles
Details about how to manage DNS and point your domain names at Flywheel.16 Articles
The most commonly asked questions, and a few we just think you should know.26 Articles
Questions that don't fit elsewhere, or those about Flywheel in general.56 Articles
Everything you need to know to get your first Flywheel site up and running.17 Articles
Everything you need to know about our amazing, free local WordPress development software for Mac and PC.20 Articles
Everything you need to know about managing your team with our Organizations feature.8 Articles
Which plugins work best, which plugins work worst, and everything in between.7 Articles
Details about everything Flywheel does to makes your site so secure.16 Articles
Information on setting up and troubleshooting with SFTP connections and file transfers.5 Articles
All there is to know about our free, automatically installed and activated SSL certificates.8 Articles
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
Everything you need to know about our Whitelabel subscriptions for branding and reselling Flywheel.3 Articles