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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

failed import mysql datebase from phpmyadmin

Discussion in 'Database Discussions' started by wp11b, Jun 7, 2012.

  1. wp11b

    wp11b Active Member

    Joined:
    Feb 23, 2009
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    56
    hi all,

    i tried to import database from phpmyadmin and i got error :

    fatal error :allowed memory size of 134217728 byte exhausted ( tried to allocate 22037143 ) in /usr/local/cpanel/base/3rdparty/phpmyadmin/libraries/import.lib.php on line 119
    fatal error :maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpmyadmin/libraries/import/sql.php

    is error at phpmyadmin or mysql ?
     
    #1 wp11b, Jun 7, 2012
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,746
    Likes Received:
    312
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Sounds like you tried to import a DB that was too large to do it that way if I was to guess. How big is it?
     
    #2 Infopro, Jun 8, 2012
  3. wp11b

    wp11b Active Member

    Joined:
    Feb 23, 2009
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    56
    mysql database 80Mb.
     
    #3 wp11b, Jun 12, 2012
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,746
    Likes Received:
    312
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, that's a bit large to be importing via your browser.
     
    #4 Infopro, Jun 12, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - failed import mysql
  1. JustinValceanu

    SOLVED cPanel & WHM update process failed

    JustinValceanu, Oct 17, 2017 at 4:52 PM, in forum: General Discussion
    Replies:
    2
    Views:
    40
    cPMarkF
    Oct 18, 2017 at 6:26 AM
  2. divemasterza

    AH00574: ap_content_length_filter: apr_bucket_read() failed

    divemasterza, Oct 11, 2017, in forum: EasyApache
    Replies:
    4
    Views:
    87
    divemasterza
    Oct 12, 2017 at 11:01 PM
  3. JohnDavid

    Email failed because of DMARC policy

    JohnDavid, Oct 11, 2017, in forum: E-mail Discussions
    Replies:
    3
    Views:
    96
    Muhammed Fasal
    Oct 12, 2017 at 8:33 PM
  4. naderslr

    The install encountered an error: Failed to extract tarball cpanel.tar.xz

    naderslr, Oct 9, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    54
    cPanelMichael
    Oct 10, 2017
  5. mvandemar

    /etc/init.d/httpd failed md5sum comparison test

    mvandemar, Oct 6, 2017, in forum: CloudLinux
    Replies:
    1
    Views:
    83
    cPanelMichael
    Oct 6, 2017

Share This Page