phpmyadmin & php.ini

[ione85]

Hello,

I have a problem setting up phpmyadmin, not in any way I can force him to import a large database of about 80 - 100 MB. I set the upload phpmyadmin to 300MB, and post_max_size to 300MB and still does not import the file because it crashes.

So messed up in the php.ini for phpmyadmin that I do not know what to do about it now that it started to finally act. Small import the database without any problem, and yet showed that in phpmyadmin I upload a maximum 300 MB it will not come.

Zip packed database takes about 5MB.
Approximately 80MB unpacked.
phpmyadmin shows (upload) 96MB

Fatal error: Out of memory (allocated 7864320) (tried to allocate 79842641 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/zip_extension.lib.php on line 60

Php.ini file looks like this: /http://prosrv.net/php.ini

[Infopro]

You should upload the database via FTP and restore it from the command line. That's really the best way to do it, even with small databases, IMHO.