Import large SQL files into Flywheel Local

Go to WordPress live website and download database using Migrate DB (Tools > Migrate DB). Install if not there.

The database will have the production URL populated in the Find column, in the Replace column enter your local URL (//website.local). Then download the database. Rename file to backup.sql and put in your websites files under {project_name}/app

Open Local by Flywheel and start your website. Right click again and find “Open Site SSH” and click. A terminal will open. Enter this code and press enter:

mysql -u root -proot -f local < /app/backup.sql

And you’re done!

See this article for more details: https://www.ibenic.com/import-databases-local-flywheel-sites/

Leave a Reply

Your email address will not be published.