Only Partial DB Refresh When Pulling from WPEngine

When I do a standard Pull from WPEngine it works but certain data from the source DB is missing.
One example is menus. Why would it pull posts but not menus?

Hi @jme77

Has this happened with multiple sites or just one?

Is it always happening or just intermittently?

If you download a backup and direct import that does the site load up with everything?

On one site.
It always happens.
I’m sure if I do a full backup and import as a new site it will work as expected.

Then my local domain and folder will change and I’ll have to connect git again.

Would be nice if the built-in db refresh took everything.

So the site is already in your Local app but you just want to bring down new DB updates? Are you selecting Include Database when you are on the MagicSync pull screen?

Yes, indeed. It brings down posts but not menus.

What version of Local are you on?

Can you share a copy of your Local Log? Retrieving Local’s Log File

Sure, no problem.

Version 7.2.1+6433

I can’t share the whole thing as there is some sensitive info in there.
Here are some mysql related errors from the log.
Hopefully that can give some insight.

{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2023-06-20T12:58:24.997172Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2023-06-20T12:58:26.902Z”}

{“thread”:“main”,“class”:“SiteProcessManagerService”,“stack”:“Error: mysqldump exited with non-zero exit code.\n at SiteDatabaseService. (%%appPath%%\main\sites\database\SiteDatabaseService.js:1:2583)\n at ()\n at s (%%appPath%%\main\sites\database\SiteDatabaseService.js:1:742)\n at process.processTicksAndRejections (node:internal/process/task_queues:96:5)”,“level”:“error”,“message”:“Unable to dump database.”,“timestamp”:“2023-06-23T20:53:21.960Z”}

{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2023-09-19T14:19:15.153379Z 0 [System] [MY-010229] [Server] Starting crash recovery…”,“timestamp”:“2023-09-19T14:19:16.005Z”}

There isn’t much there to point at a specific culprit. It could either be an issue with the database (a certain table/row that is causing an error) or some issue with the hardware in your machine. I’m assuming there is plenty of space on your harddrive and no indications that it would be corrupted?

If you’d prefer not to share more specific details here it might be best to reach out to WPE support directly. Then they can spin up a ticket where you can share your full local logs privately. Additionally, we may want to get the name of the install you’re working on so we can test pulling/importing it on our end with your permission as well.

Ok, will do. Yep no fundamental issues like that.
Thanks anyways Nick.

1 Like

By the way I did find a workaround.

I downloaded the full backup from WPEngine.
Extracted the sql dump from the zip.
Opened Adminer on my local environment.
Imported the SQL dump.
It ran for a while, threw an error, but the missing data has been added.

1 Like

Glad you were able to get it working! Thank you for the follow up.

1 Like

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.