The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpmyadmin & php.ini

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

  1. ione85

    ione85 Registered

    Joined:
    Feb 10, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    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:
    14,447
    Likes Received:
    195
    Trophy Points:
    63
    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.
     
Loading...

Share This Page