Trying to import a database using Adminer.
The Database is 190Mb, but when I try to import using Adminer, I get the following error:
Allowed memory size of 268435456 bytes exhausted (tried to allocate 186937472 bytes) in /Applications/Local.app/Contents/Resources/extraResources/adminer/adminer.php on line 100
System Details
Local Logs
Attach your Local Logs here (Help Doc - Retrieving Local’s Log )
Security Reminder
local-lightning-verbose.log (866.1 KB)
Hey @theleadagency , welcome to the forums!
We have a feature request to make it easier to allow increasing the memory for Adminer. Take a look and vote on it so it get prioritized:
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:
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 .…
That linked forum topic also has a workaround for getting the large DB into a Local site.
1 Like