Personal notes
Login to PhpMyAdmin :
http://phpmyadmin.christinewilson.ca/
Login to PhpMyAdmin:
http://localhost/phpmyadmin/
This creates an empty database with correct user assigned. WordPress will do rest when you upload files
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/
MAC OS
/Applications/MAMP/Library/bin/mysql -u root --password wp_schleese < schleese.sql
Windows
C:/xampp/mysql/bin/mysql.exe -u root --password wp_schleese < schleese.sql