PHP memory limit error when importing / Failed to get current SQL modes. Reason: ERROR 2003 (HY000)

[Nick-B]

Hi @buzztone - I merged your thread in here just to keep all troubleshooting and comms in the same place.

As mentioned, there could be different culprits potentially for this same error.

With Windows it’s always a good idea to just perms and privileges:

Duplicate existing Local site into another Local instance

Thanks for the feedback, Nick! After you pointed out the logs mentioned Operation Not Permitted, I realized I probably knew the answer. Windows runs applications with less privileges by default. My suspicion is that this caused the error! I then went to the Start Menu or start search bar, searched for Local, then right-click and “Run as administrator” to open the application with full privileges. Magically, the import process starts! I wonder if others on this forum complaining about Windows …

There is also a workaround mentioned Ben here that might work as well:

Cannot import database through SSH

Hey @emsixteen – It looks like this is a bug with how Local is setting up the shell environment. As a work around, you can manually update the wp-config.php for the site to include the port number for the database: [image] I’ll file a bug with the Local bug tracker so that we can get someone to look into and fix this!

@Mike8040 or @tnaughton If you’re still having issues please share your Local Logs and we can try and take a further look.