Database insert memory

[giorgoskey]

What issue or error are you experiencing?

I am trying to insert a DB that is about 250MB, the limit is 1GB. The process stops unsuccessfully and I get the message:
]
Fatal error : Allowed memory size of 268435456 bytes exhausted (tried to allocate 259310400 bytes) in C:\Users\User\AppData\Local\Programs\Local\resources\extraResources\adminer\adminer.php on line 100

I increased all memories at my conf/php/php.ini but the problem remains.

any help?

thanks
Giorgos

System Details

nginx
MySQL 8.0.16
WP 6.4.3

local-logs.zip (5.1 KB)

[Nick-B]

Hey @giorgoskey! This is a known limitation in Local at the moment. We have a feature request here to allow adjustments for this value. Feel free to upvote, comment or follow along. In the meantime your best bet will be to manually import the database as a workaround. Details at the bottom of this post:

Allow Users to Raise the Memory Upload Limit for Adminer

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.…

[giorgoskey]

Hello Nick, I do as the troubleshooting asks:

1. move my sql to app/public
2. site shel this command: wp db import sites5_proinos.sql

and I get the error:
Error: Failed to get current SQL modes. Reason: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)

Then I run the Local program as administrator and still got the same issue. I read more and I change the wp config options as suggested to:
define( ‘DB_HOST’, ‘localhost:10005’ ); 10005 is my localhost

and now I get the message:
ERROR 1045 (28000): Access denied for user ‘sites5_proinos’@‘localhost’

I am a bit confused here…

[Nick-B]

Hey @giorgoskey

Just to check a few things here that could be getting in the way:

• Do you have any antivirus, security, or firewall applications that could be blocking Local? If so, can you try temporarily disabling them or see if they have a setting that will “allow” Local to proceed?

• Can you check if your Hosts File is read only? Help! I’m running into an EPERM error with the hosts file on Windows

• Are you running other developer applications simultaneously? That could also cause similar issues. Apps like MAMP, XAMPP, or Docker for example.

• Lastly, if you’re still having trouble does the issue persist when downgrading your Local version? Downgrade Local Version - Local