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

Continuing the discussion from Adminer memory exhausted:

I’m getting this error on a blank WordPress install.

What issue or error are you experiencing?

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 130023456 bytes) in C:\Users..\AppData\Local\Programs\Local\resources\extraResources\adminer\adminer.php on line 98

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

Importing 26.7 MB sql.gz database created by WP Migrate Lite

System Details

  • Local Version:
    Version 8.1.0+6514

  • Operating System (OS) and OS version:
    Windows 11 Pro

Local Logs (79.3 KB)

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.