Memory size error when importing sql.zip file into phpmyadmin

Question

I'm having issues importing a sql.zip file into phpmyadmin. When I try to import the file I get the following error:
Fatal error:

Allowed memory size of 134217728 bytes exhausted (tried to allocate 132382880 bytes) in /usr/share/phpmyadmin/export.php on line 310

I've gone into the config file and the memory_limit is set to -1 (would it be better to set the limit?) and when I navigate into the export.php file I can't find a reason for the error. As far as I know the export.php file is still default, no one has edited the file. Here's an image of the line (cursor marking line 310)

I've been beating my head against this for ages, any help would be appreciated.

It is either something in the sql.zip file that is causing the problem or the zip file is exceeding the file size limit. — user2417483
– user2417483, Commented Nov 28, 2018 at 4:58
Why import the DB via PHP? Just do it via the mysql interface, it is very straight forward — user3783243
– user3783243, Commented Nov 28, 2018 at 5:11
What about upload_max_filesize, post_max_size, max_execution_time and max_input_time? — trpx
– trpx, Commented Nov 28, 2018 at 8:01

Walter Cejas · Accepted Answer · 2018-11-28 05:26:46Z

0

Check this answer https://stackoverflow.com/a/4546797/5458355. With a terminal, having mysql in your global path, try:

mysql -u <username> -p <databasename> < <filename.sql>

Is faster to import the db from terminal and you must do it if the file is too big... check also your Apache limits for file upload and memory limit.

answered Nov 28, 2018 at 5:26

Walter Cejas

2,1531 gold badge17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Memory size error when importing sql.zip file into phpmyadmin

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related