Import a database to production/staging site

Flywheel’s Database Manager allows you to import a single WordPress database in .sql format to your production or staging site. Learn more about Database Manager.

This guide will walk you through the import process as well as provide some post-import tips to help ensure your new database plays nicely with your WordPress install.

How to import a database to production

1. We suggest making a new backup before making any database changes to your production site.
2. From the Sites page, click on the appropriate site.
3. Navigate to the site’s Advanced tab.
4. On the Database card in the right sidebar, click the Manage Database button to open Flywheel’s Database Manager.
5. Select the Import tab.
6. Click Choose File and browse your computer for the database file (must be .sql format and 50mb or less).
7. Click the Import File to upload the database to your production site.
8. If necessary, update the database prefix on Flywheel for your production site.
9. If necessary, update domains and links to the primary domain.

How to import a database to staging

1. Flywheel doesn’t offer backups for staging sites at this time, but if you’re concerned about losing data, we suggest backing up your staging database using a plugin such as WP Migrate.
2. From the Sites page, click on the appropriate site.
3. Navigate to the site’s Staging tab. (If you don’t see it, make sure staging is enabled.)
4. On the Database card in the right sidebar, click the Manage Database button to open Flywheel’s Database Manager.
5. Select the Import tab.
6. Click Choose File and browse your computer for the database file (must be .sql format and 50mb or less).
7. Click Import File to import the database to your staging site.
8. If necessary, update the database prefix on Flywheel for your staging site.
9. If necessary, update domains and links to the staging domain.

If necessary, update the database prefix

Your production site’s prefix can be configured from the Advanced tab of the site’s Flywheel dashboard on the Database card. This value should match the database’s actual prefix.

1. To confirm your database’s actual prefix, click Manage Database.
2. Enter the term “users” in the search bar. This will bring up the users table, which is a trustworthy indicator of the database’s prefix.
3. The database prefix is an identical string of characters at the beginning of every single table name in your database. The default is “wp_” but frequently varies. Prefixes almost always end with an underscore. In this example, the database prefix is “wp_”.
4. If the prefix value on your site’s Database card differs, you can update it.
5. Hover over the Database card to reveal the 3-dot menu icon next to the prefix, and click Change.
6. Enter the database’s actual prefix and click Change Prefix.

If necessary, update domains and links to the primary (or staging) domain

Often, the domain which was being used to build the original site will still remain in the database after it’s imported to Flywheel. If this doesn’t match the domain set as primary (or staging) on Flywheel, the site may not load correctly.

You can easily run a search-and-replace for the domain by using a plugin like Better Search Replace, or by using SQL commands inside the Database Manager. Otherwise, feel free to reach out to Flywheel Support to help with a search-and-replace.

Need help?

If you have any questions our Happiness Engineers are here to help!