Menu

How to migrate your site to Flywheel manually

Updated on June 1st, 2022

Note

Manually migrating your site is usually the most time-consuming and complicated method. But, sometimes using a plugin isn’t an option, or you may simply have the files for your site (like a Flywheel generated backup).

That said, if your site is live on another host or is running on a local dev environment, we recommend trying one of the following methods:

Migrating your site to Flywheel using Flywheel Migrations
Migrating your site to Flywheel using BackWPup


Table of Contents:

1. Back up your site’s files
2. Export your site’s database
3. Upload your site files to Flywheel via SFTP
4. Upload the database SQL file via the Database Manager
5. If necessary, update the database prefix
6. If necessary, update domains and links to the Flywheel temporary URL


Note

If you already have your site’s files and database handy, perhaps from a Flywheel generated backup, you can skip ahead.

Back up your site’s files

  1. Log into your current host’s cPanel and open the File Manager, or access your site’s file system via FTP.
  2. Download the wp-content folder (and any other root-level files or folders you wish to move over to Flywheel) to your local machine.

Note

If you have issues accessing the file system or locating your wp-content folder, we suggest reaching out to your current host for assistance.

Export your site’s database

  1. Log into your current host’s cPanel and access your database using phpMyAdmin.
  2. Export your database in SQL format, making sure to include all tables.

Note

If you have issues exporting your site’s database, we suggest you contact your current host for assistance.

Upload your site files to Flywheel via SFTP

  1. If you haven’t already, create a new site on Flywheel.
  2. Log in to your Flywheel SFTP account, and open the destination site folder. (If you’re not sure how to connect to your Flywheel site via SFTP, check out this help article: How to access your site via SFTP.)
  3. Open up the wp-content folder of the destination site, and begin copying the files over from your local computer’s wp-content folder to your Flywheel site.

Note

When uploading these files to Flywheel, you can either overwrite the existing themes, plugins, and uploads folders, or you can merge them with the files already present. Just be sure that all the files from the backup’s wp-content folder are uploaded to the wp-content folder of the destination site.

Note

Core Files: As a managed wordpress host, Flywheel takes care of the WordPress core for you. This means you don’t need to upload any core files (in fact, those folders are locked down and inaccessible via SFTP).

Upload the database SQL file via the Database Manager

  1. Log in to your Flywheel dashboard and find your site.
  2. Navigate to the Advanced tab and locate the Database card. Click the Manage Database button.
  3. Select the Import tab.
  4. Click Choose File and locate the backup’s database file (the file with the .sql extension)
  5. Click Import File.

If necessary, update the database prefix

Your 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. Click the 3 dot menu icon next to the prefix and click Change.
    Change the database prefix in the Advanced tab of the site's Flywheel Dashboard
  6. Enter the database’s actual prefix and click Change Prefix.

If necessary, update domains and links to the Flywheel temporary URL

Depending on how the original site was built and how it stores its data in the database, this step may not be necessary. Often, the domain which was being used to build the original site being imported will still remain in the database.

You can easily run a search-and-replace by using a plugin like Better Search Replace, or by using SQL commands from the Advanced tab of the site’s Flywheel Dashboard, if you’re comfortable doing so. Otherwise, feel free to reach out to Flywheel Support for a search-and-replace.


Still need help?

If you run into any snags migrating your site, get in touch with our Happiness Engineers, they’ll be happy to help point the way!

Was this article helpful?

Getting Started

New to Flywheel? Start here, we've got all the information you'll need to get started and launch your first site!

View all

Account Management

Learn all about managing your Flywheel user account, Teams and integrations.

View all

Billing

Everything about billing, invoices and payments can be found here.

View all

Features

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

Platform Info

All the server and setting info you'll need to help you get the most out of your Flywheel hosting plan!

View all

Site Management

Tips and tricks for managing your sites on Flywheel, including going live, troubleshooting issues and migrating or cloning sites.

View all

Growth Suite

Learn more about Growth Suite, our all-in-one solution for freelancers and agencies to grow more quickly and predictably.

View all

Managed Plugin Updates

Learn more about Managed Plugin Updates, and how you can keep your sites up to date, and extra safe.

View all

 

Flywheel help

Help is just a click away! Log into the Flywheel dashboard to instantly chat with an expert, open a ticket, or follow along with in-depth documentation. We happily offer support 24 hours a day, 7 days a week, 365 days a year!

Log in

Try Flywheel today

Launch your next WordPress site in minutes.

 Free migrations  24/7/365 support  14 day demo sites