CODEWITHSUNDEEP
phpmysqlphpmyadminwamp
CodeManiac
CodeManiac

Reputation: 1014

Allowed Memory size exhausted

I have wamp and change configuration in php.ini still show below error while importing zip sql file to database in phpmyadmin

Allowed memory size of 67108864 bytes exhausted (tried to allocate 69931615 bytes) in C:\wamp\apps\phpmyadmin3.5.1\libraries\zip_extension.lib.php

I have changed following to php.ini:

upload_max_filesize = 32M

memory_limit = 64M

post_max_size = 120M

I have zip file to imort is size of 16.1 MB

Upvotes: 3

Views: 10819

Answers (1)

Your Common Sense
Your Common Sense

Reputation: 157896

Well, change it again.
A 16.1 MB zip may contain a 120MB SQL file. And PHPmyAdmin may want some for itself.

Just set your memory_limit to 512M or try to import files of lesser size.

Another opportunity is to unzip your file manually and then feed it to mysql console app or Sypex Dumper

Upvotes: 4

Related Questions