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!

failed import mysql datebase from phpmyadmin

Discussion in 'Database Discussion' 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:
    16,741
    Likes Received:
    456
    Trophy Points:
    583
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    16,741
    Likes Received:
    456
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, that's a bit large to be importing via your browser.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 Infopro, Jun 12, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - failed import mysql
  1. story_gooo

    The system failed to import data from the RRDTool files

    story_gooo, Oct 24, 2017, in forum: Data Protection
    Replies:
    3
    Views:
    562
    cPanelMichael
    Oct 26, 2017
  2. rendy alexander

    Failed to start Apache SpamAssassin error

    rendy alexander, Mar 14, 2019 at 12:59 AM, in forum: General Discussion
    Replies:
    1
    Views:
    191
    cPanelLauren
    Mar 14, 2019 at 9:56 AM
  3. CharlesGLondon

    Failed to add recipient Unexpected failure

    CharlesGLondon, Mar 13, 2019, in forum: E-mail Discussion
    Replies:
    2
    Views:
    396
    CharlesGLondon
    Mar 14, 2019 at 11:13 AM
  4. raudabaugh

    Pruning of backups from failed transports

    raudabaugh, Mar 12, 2019, in forum: Data Protection
    Replies:
    5
    Views:
    151
    cPanelLauren
    Mar 15, 2019 at 3:44 PM
  5. pmcgilli

    In Progress [CPANEL-26179] Starting Spamd errors out with The system failed to execute the system call setrlimit

    pmcgilli, Mar 11, 2019, in forum: E-mail Discussion
    Replies:
    2
    Views:
    283
    cPanelLauren
    Mar 12, 2019

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.
    Accept Learn More...
    Dismiss Notice