ManageWP has a beta feature that allows you to sync between live site and local staging site but I’m having trouble getting it to play ball with Local. Here’s an overview of my setup and tests so far:
- Windows 10 with both Local (newer) & Local by Flywheel installs
- Live site hosted on Siteground running PHP 7.3.14 & MySQL 5.6.36
- Local by Flywheel site running PHP 7.2.9 & MySQL 5.7.23
- Local site running PHP 7.3.5 & MySQL 8.0.16
- Trying to sync from Live site -> Local
When trying on the newer local install I get stuck on the following error:
We got an error while calling http://apppresserdev.local/?list_tables: [db_connect_error]: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. : 2002 If retrying doesn’t help, please contact our support.
When trying on the older local by flywheel install it throws some other minor errors but the process actually appears to run ok and completes the sync.
So there’s something different about the newer Local installation causing this error. The first thing that stands out is the bump in MySQL version but I’m not really sure beyond that how to troubleshoot or resolve this. Any ideas?
EDIT: Also tried a MariaDB 10.4.10 install on new local and got the same error as above.