4
Issues pushing site when Local MySQL version is newer than remote version
E
Evan Wiegand
When my site is pushed from Local --> WPE, the database does not fully upload, resulting in error establishing a database connection. Verifying by phpMyAdmin, only about 2-3 db tables have uploaded to WPE. (Though Local always indicates success with "Site pushed! Your site has been pushed to WP Engine")
This occurs even if I pull a working site down from WPE, verify that it's working properly in Local, and immediately push back to WPE without making any site changes.
Contacted WPE support. They first verified that my API access was setup correctly and later found this is a known bug: "the SSH connection times out during the mysql import, resulting in only some tables getting imported," but I haven't seen it posted on here yet. They suggested that it would hopefully be fixed in this new version (5.6.1) but I just updated and this has not resolved it.
Local log file:
Local 5.6.1+4184 (and 5.5.3 too)
MacOS 10.14.6
Activity
Newest
Oldest
Benjamin Turner
Thanks for clarifying things Evan Wiegand!
I'm going to update the heading to better reflect what the bug is. Specifically, change the current heading of:
Error establishing a database connection after pushing to WP Engine
to
Issues pushing site when Local MySQL version is newer than remote version
E
Evan Wiegand
An update for anyone who needs it: This ended up being caused by the original site/database being created with an older version of MySQL 5.x. Working with the site in Local and pushing to WPE, which were both by default running MySQL 8.x, resulted in communication errors and an inability to push the database successfully.
WPE agent (Thanks Michael P!) confirmed this is considered a Local bug, since other migration plugins handled this without issue.
Workaround for now is to create a brand new site in Local and choose an older 5.x MySQL version under the custom options during the setup process. Then pull down your site from wherever --> Local. Then reset the WPE destination environment back to a default/initial install state, then push from Local --> WPE. Worked for me!