Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.
In the logs, I’m seeing this error, which doesn’t give us much to go on:
{"level":"error","message":"Error: mysqldump exited with non-zero exit code: 2\n at SiteDatabaseService.<anonymous> (%%appPath%%\\main\\sites\\database\\SiteDatabaseService.js:1:2698)\n at Generator.next (<anonymous>)\n at s (%%appPath%%\\main\\sites\\database\\SiteDatabaseService.js:1:849)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","thread":"worker","timestamp":"2024-01-08T15:10:26.909Z","worker":"exportSiteWorker"}
If you access the site in the browser, does it still work? For example, are you still able to see pages and navigate the site?
If you can interact with the site still, you might try manually exporting the DB using the site shell. To do this:
Click the “Open site shell” button on the Local site over view page
In the terminal that opens, export the DB running this command:
wp db export
Can you let me know if the site still works as well as what happens when running the wp db export command?
Yes when I go to the website, everything is working perfectly. All plugins work, all users are there, etc
When I opened the shell prompt, I got this
G:\localsites\esmedia\app\public>wp db export
‘grep’ is not recognized as an internal or external command,
operable program or batch file.
Warning: Failed to get current character set of the posts table. Reason: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
mysqldump: Got error: 2003: Can’t connect to MySQL server on ‘localhost’ (10061) when trying to connect
Had some success. I used a plugin (ai1wm) on the localwp site to do a backup and then imported it to the new wordpress server. All info seems to have been transferred across.
