Working with clients with WordPress sites can be difficult when you have to migrate their site locally so you can develop on it. If you’re using Local by Flywheel the site is hosted on Flywheel, you will have no problem. If their site is not a big one, you’ll also have no problem using some of the existing solutions such as WP Migrate DB Pro and alike. But what if your site has large databases (read tens of GB), what to do then? In this tutorial, I’ll show you how to migrate such large databases in Local by Flywheel through SSH.
If you don’t have Local By Flywheel, please go download it and install it so you could follow this guide. Also, create a site using it. I mostly use the custom environment. This tutorial will also assume that you have commands such as ssh, tar, scp and gunzip installed on your environment. If not, you can still follow most of it (ignore the downloading part).
1. Get the Database
This is an obvious step, right? You will need to get the database. When we’re working with such large databases, you will probably get them gzipped. If not, your database will be either in .sql or in .zip.
Some hosting providers will have an option to export
Source: https://managewp.org/articles/17911/how-to-import-large-databases-in-local-by-flywheel-sites
Willie Chiu's Blog 