How can I resolve this issue? I have 8GB of system memory on my PC so I imagine this is a setting issue. I can’t import the SQL file until this is resolved. Please help.

Hi Cody, In this case I would recommend using MySQL CLI (command line) to get this job done. Here’s what you can do: Move the SQL file into the site’s /app directory (untar it if it’s tar/gzipped) Right-click on the site in Local’s sidebar and go to “Open Site SSH” Enter mysql -u root -proot loc…

Adminer running out of memory upon sql import - Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 174873888 bytes) in /etc/scripts/local-adminer.php on line 92

Support

cpsharp July 7, 2017, 5:56pm 4

Thanks Clay!

PHP memory limit error when importing a SQL file in Adminer

Topic		Replies	Views
PHP memory limit error when importing a SQL file in Adminer Support adminer	6	6073	September 8, 2021
Can't import database via Adminer nor via site shell Support windows	3	358	February 3, 2024
DATABASE EMPTY after import, HELP! Support	4	4901	August 25, 2020
Increase Adminer database limit Support windows	4	1236	June 21, 2023
(ERROR) Importing Missing SQL Database Via Adminer Support	1	535	October 18, 2021

Adminer running out of memory upon sql import - Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 174873888 bytes) in /etc/scripts/local-adminer.php on line 92

Related Topics