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,419
    Likes Received:
    285
    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,419
    Likes Received:
    285
    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. keat63

    failed to lock global mutex

    keat63, Jun 20, 2017 at 9:23 AM, in forum: Security
    Replies:
    7
    Views:
    55
    keat63
    Jun 22, 2017 at 7:00 AM
  2. calamus

    Broken site due to failed redirect

    calamus, Jun 15, 2017, in forum: General Discussion
    Replies:
    5
    Views:
    47
    Infopro
    Jun 15, 2017
  3. Zabidin

    SOLVED cPanel update failed

    Zabidin, May 28, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    136
    Zabidin
    May 29, 2017
  4. bruzli

    The system failed to parse the JSON stream data

    bruzli, May 26, 2017, in forum: General Discussion
    Replies:
    4
    Views:
    111
    cPanelMichael
    Jun 14, 2017
  5. chris0147

    cPanel license update failed

    chris0147, May 25, 2017, in forum: Security
    Replies:
    3
    Views:
    266
    Infopro
    May 25, 2017

Share This Page