Allow Users to Raise the Memory Upload Limit for Adminer

[Nick-B]

Currently, the Memory Limit for Adminer is hard-coded at 256 MB which means if you’re importing a large database you might get an error like these:

Increase memory limit of mysql server beyond 256M

What issue or error are you experiencing? Importing large SQL file using Adminder breaks at 256M What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc Import large SQL file, mine was 800MB Changing the PHP memory (as per this topic How to increase the PHP memory limit beyond 256MB for adminer on macOS ) does not affect the Memory available to Adminer. Fatal error : Allowed memory size of 268435456 bytes exhausted (tried to allocate 891451216 bytes) in /…

Error on DB import with Adminer

What issue or error are you experiencing? Error on import of db (~ 350mb in size) Fatal error : Allowed memory size of 268435456 bytes exhausted (tried to allocate 321598096 bytes) in /Applications/Local.app/Contents/Resources/extraResources/adminer/adminer.php on line 100 Is this an issue with memory allocation, and if so, how can I address it? Thank you! System Details Local Version: Version 9.0.2+6676 Operating System (OS) and OS version: macOS Sonoma 14.2.1

A note that this is not related to the PHP Memory value set in php.ini which you can edit to a larger value. Steps for this are included at the bottom of our Troubleshooting Performance Issues help article here.

The workaround for the Adminer error is to manually import the database file as mentioned in our Manually Importing a Local Site guide. The steps would look like this:

• Copy the correct SQL file to the site root (App>Public)

• Within Local, click Open Site Shell

• Import your Database with wp db import your-database-filename.sql

• If that works, now Search and replace the domains. This might require more than one S/R, for example:

wp search-replace production.com mysite.local
wp search-replace https://mysite.local http://mysite.local