Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

phpmyadmin & php.ini

Discussion in 'Database Discussion' started by ione85, Feb 10, 2012.

  1. ione85

    ione85 Registered

    Joined:
    Feb 10, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    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

    Code:
    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
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,234
    Likes Received:
    383
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice