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.

[Case 75085] phpMyAdmin Export

Discussion in 'Database Discussions' started by rcann, Aug 13, 2013.

  1. rcann

    rcann Registered

    Joined:
    Mar 28, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New Jersey
    phpMyAdmin version 4.0.4.2 asof today:
    Firefox (latest) from Centos 6: databases, tables etc. have red exclamation point. Not true in OSX 10.6.8, XP or Win7.

    Can't export a database. Simply click "Export" after logging in and selecting a database:
    "Firefox can't find the file at http://<a website on server>:2082/cpsess<unique session id>/3rdparty/phpMyAdmin/export.php." Happens across all platforms and websites.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    I moved this post into it's own thread because it was not related to the thread you posted it on.

    Could you let us know the size of the databases you are attempting to export? Are any of them under 50M?

    Thank you.
     
  3. brunomenoli

    brunomenoli Active Member

    Joined:
    Sep 2, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brazil
    Same problem here, database with 47 MB Two servers with cpanel with problems
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Do you notice any specific error messages in the phpMyAdmin interface or in the cPanel error log (/usr/local/cpanel/logs/error_log)?

    Thank you.
     
  5. brunomenoli

    brunomenoli Active Member

    Joined:
    Sep 2, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brazil
    Please see:

    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 51353601 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/Response.class.php on line 273

    - - - Updated - - -

    Please see:

    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 51353601 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/Response.class.php on line 273
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It's possible this is related to internal case number 75085. What version of cPanel is installed on your system? Have you tried increasing the "Max cPanel Process Memory" option via "WHM Home » Server Configuration » Tweak Settings"?

    Thank you.
     
  7. brunomenoli

    brunomenoli Active Member

    Joined:
    Sep 2, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brazil
    CENTOS 6.4 x86_64 standard – XXXXX WHM 11.38.2 (build 1)

    I tryed incresing to 2 GB, but the same error:
    Updating tweak settings...


    Your changes have been saved.

    Restarting cPanel daemons...done.

    Updating your system to reflect any changes...
    Updating Max cPanel process memory from “1024” to “2048”.
    Max cPanel process memory was updated.



    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 51353601 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/Response.class.php on line 273

    - - - Updated - - -

    CENTOS 6.4 x86_64 standard – XXXXX WHM 11.38.2 (build 1)

    I tryed incresing to 2 GB, but the same error:
    Updating tweak settings...


    Your changes have been saved.

    Restarting cPanel daemons...done.

    Updating your system to reflect any changes...
    Updating Max cPanel process memory from “1024” to “2048”.
    Max cPanel process memory was updated.



    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 51353601 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/Response.class.php on line 273
     
  8. rcann

    rcann Registered

    Joined:
    Mar 28, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New Jersey
    Hi Michael,

    Thanks for the reply. The one I was trying is 56M. Regards.
     
  9. rcann

    rcann Registered

    Joined:
    Mar 28, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New Jersey
    I have: CENTOS 5.9 i686 standard – WHM 11.38.2 (build 1)

    I looked at the error log per suggestion. Exactly same error as brunomenoli. So I upped the process limit to 2GB as well, and tried the export on both a .5G database and the same 57M. Here's the error_log:

    [2013-08-13 15:59:07 -0400] warn [whostmgr2] Action for autodiscover_proxy_subdomains failed to update value (). This setting will not be updated. at whostmgr/bin/whostmgr2 line 4734
    main::dotweaksettings() called at whostmgr/bin/whostmgr2 line 1142
    Restarting cpsrvd daemon process 4253 via /usr/local/cpanel/cpsrvd-ssl
    ==> cpsrvd 11.38.2.1 started
    ==> cpsrvd: preloaded ssl_write_all!
    ==> cpsrvd: loading security policy....Done
    ==> cpsrvd: Setting up native SSL support ... Done
    ==> cpsrvd: transfered port bindings
    ==> cpsrvd: bound to ports

    ((( .5G database:

    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 126883841 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php on line 378

    Previous check_sessions still running with pid: 26141. Possible cpsrvd denial of service attack in progress.

    (((57M database:
    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 60467201 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/Response.class.php on line 273

    Regards
     
  10. brunomenoli

    brunomenoli Active Member

    Joined:
    Sep 2, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brazil
    Some Update?
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Internal case number 75085 is open to address this issue. There is currently no specific time frame on when a solution may be implemented. I will update this thread with more information as it becomes available. Currently, the workaround is to export the database manually through the command line. EX:

    Code:
    mysqldump database_name > /path/to/exported_database.sql
    Thank you.
     
  12. dannette

    dannette Registered

    Joined:
    Apr 27, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I am having problems as well, however I never noticed a message about memory - mostly page not found errors. I did a download just last week and it was just fine. We are running: CENTOS 5.9 x86_64 standard WHM 11.38.2 (build 1). I'm not sure when it updated. I have 2 more servers to check. Thanks for the command line Michael - that helped tremendously.
     
  13. Aita

    Aita Member

    Joined:
    Sep 16, 2010
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Sweden
  14. AirHost

    AirHost Member

    Joined:
    Jan 26, 2013
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I've done that and it doesn't fix it.
     
  15. Lor

    Lor Well-Known Member

    Joined:
    Apr 29, 2005
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    I have the problem to: phpmyadmin exported small files(~10Mb) partially. Big file(~1G) not working at all in all browsers: message from browser "Can't find host ... "

    And I very upset with the new interface in last versions ... :mad:

    How to downgrade phpmyadmin to previously versions?
     
    #15 Lor, Aug 18, 2013
    Last edited: Aug 18, 2013
  16. nrm

    nrm Member
    PartnerNOC

    Joined:
    Jan 11, 2007
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Moscow, Russia
    I have the same problem when you fix this problem?
     
  17. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    A resolution for this case is scheduled for inclusion with cPanel version 11.38.2.3. There is currently no specific time frame available on when this version will be pushed out to the release tiers.

    Thank you.
     
  18. dmacleo

    dmacleo Active Member

    Joined:
    Jan 28, 2012
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    11.39.0.12 still has the issue.
    I accidentally set preferences to edge and auto update w/o realizing.
    and I cannot find a way to getback to 11.38
     
  19. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To update, it's been determined that this is a flaw with phpMyAdmin itself:

    phpMyAdmin / Bugs / #4046 Exporting huge Tables causes memory-Problems

    The workaround will be to continue to export the database through the command line or by downloading the database in cPanel until phpMyAdmin has issued a resolution for this bug. Case 75085 will ensure a notice is placed in phpMyAdmin informing users that exporting large databases may fail.

    You can not downgrade to cPanel 11.38 after you have upgraded to cPanel 11.40 (11.39 development build).

    Thank you.
     
  20. SigmaWeb

    SigmaWeb Active Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    28
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Athens - Greece
    cPanel Access Level:
    Root Administrator
    Hi,
    I still experience the issue even in 11.38.2.3 with the new phpmyadmin 4.0.5

    Thanks
     
Loading...

Share This Page