允许的内存容量已用尽 [英] Allowed Memory size exhausted

问题描述

当我将zip sql文件导入phpmyadmin中的数据库时，我在php.ini中进行了改动并更改了配置，仍然显示以下错误

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

我已将以下内容更改为php.ini:

upload_max_filesize = 32M

memory_limit = 64M

post_max_size = 120M

我要下载的zip文件大小为16.1 MB

解决方案

好，再次更改.
16.1 MB的zip可能包含120MB的SQL文件.并且PHPmyAdmin可能想要一些它自己.

只需将您的memory_limit设置为512M或尝试导入较小尺寸的文件即可.

另一个机会是手动解压缩文件，然后将其输入到mysql控制台应用程序或 Sypex Dumper

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

解决方案

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

这篇关于允许的内存容量已用尽的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！