Increase memory limit of mysql server beyond 256M

Support
1

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 /Applications/Local.app/Contents/Resources/extraResources/adminer/adminer.php on line 100

System Details

  • Local Version:
    9.0.2+6676

  • Operating System (OS) and OS version:
    MacOS

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

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.

2

Hi @hyperterry

You should be able to get around this by manually importing the SQL file. The steps from Ben here should work:

3

okay that does the trick via console command, though means you need to override URL in wp-config.
I would still like to increase memory for Adminer since it’s easier than always using console to import and then having to replace URLs afterwards. Sometimes I need the URL to be correctly set as .local before loading the site so it doesn’t try to process subscriptions.

define(‘WP_HOME’, ‘http://something.local’);
define(‘WP_SITEURL’, ‘http://something.local’);

5

Hi @hyperterry

I checked with the Devs on this and the value for adminer memory is actually hard coded. I spun up a feature request here to make this an editable value for users. For now, the only workaround will be the manual import steps, but please vote, comment, and follow along here for future updates.

6

Thanks, voted.

2 Likes