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!

phpMyAdmin export error

Discussion in 'Database Discussion' started by never2far, Mar 18, 2013.

Page 1 of 2
  1. never2far

    never2far Active Member

    Joined:
    May 6, 2008
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    56
    Hello,

    I have a strange problem when I'm trying to export a small database using phpmyadmin. From my tests this problem occur only if I'll choose Compression.

    Some info that can be useful:

    - Database has 11.3 MB
    - cPanel version - 11.36.0.14
    - PhpMyAdmin Version information: 3.5.5

    Steppes to reproduce this error:

    - login on 2083 -> PhpMyAdmin
    - Export
    - Custom - display all possible options
    - choose a database
    - Save output to a file
    - Compression: gzip (i have tried all and it's the same)
    - Format: SQL
    - press GO
     
    #1 never2far, Mar 18, 2013
  2. never2far

    never2far Active Member

    Joined:
    May 6, 2008
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    56
    Am I the only one that have this problem ...or ?!
     
    #2 never2far, Mar 19, 2013
  3. whizsper

    whizsper Registered

    Joined:
    May 24, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Bump this.

    I'm having the exact same issue as described by never2far.
     
    #3 whizsper, Mar 22, 2013
  4. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    49
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    You're not alone, upgraded to 11.36.014 last night, and can no longer export using gzipped.

    Ironically, this is what I'm seeing too.

    The database is around 12M uncompressed, 2M compressed.

    I can export smaller databases, both compressed and uncompressed.

    I cannot export the 12M database compressed.

    I can export the 12M database uncompressed.

    Not sure if the is related, but I also get a blank screen when I hit the "home" icon.

    PHP version 5.3.22
    mysql (5.1.68-cll)

    This happens on Chrome, Firefox and IE 10.

    Never saw this before the upgrade.

    Bill
     
    #4 BillyS, Mar 22, 2013
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,563
    Likes Received:
    437
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Please open a ticket to cPanel Support if you're concerned that this was caused due to a cPanel update.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 Infopro, Mar 22, 2013
  6. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    49
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    I'll open a ticket in a day or two. Going to see if I can solve it first. In case someone else see this, the error in Chrome is given as:

    cpsess1234567890/3rdparty/phpMyAdmin/export.php
     
    #6 BillyS, Mar 22, 2013
  7. never2far

    never2far Active Member

    Joined:
    May 6, 2008
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    56
    I'll open a ticket too ...this problem start to be annoying for the clients that use phpMyAdmin to export databases.
     
    #7 never2far, Mar 23, 2013
  8. CaptainC

    CaptainC Registered

    Joined:
    Sep 5, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    +1 I have the same problem since the server was upgraded
     
    #8 CaptainC, Mar 25, 2013
  9. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    49
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    CPanel upgraded to 11.36.0 (build 18) last night, and the export feature seems to be working again.
     
    #9 BillyS, Mar 26, 2013
  10. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    49
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Still not working even with build 21. Anyone have any ideas?
     
    #10 BillyS, Apr 8, 2013
  11. never2far

    never2far Active Member

    Joined:
    May 6, 2008
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    56
    Let's hope cPanel stuff will review this topic :)
     
    #11 never2far, Apr 20, 2013
  12. ethical

    ethical Well-Known Member

    Joined:
    Apr 7, 2009
    Messages:
    88
    Likes Received:
    4
    Trophy Points:
    58
    am also having this issue. cpanel wheres the fix?
     
    #12 ethical, May 2, 2013
  13. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Please submit a support ticket so we can take a closer look and attempt to reproduce this issue. You can open a support ticket using the following URL:

    Submit A Ticket

    Let us know the ticket number and we can report back any findings to this thread.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #13 cPanelMichael, May 2, 2013
  14. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    49
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    This appears to be a problem with phpmyadmin and IE10. The near term fix is to run in compatibility mode. Over the long term it looks like it will be fixed in phpmyadmin 4.0 or later.
     
    #14 BillyS, May 17, 2013
  15. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Did you end up opening a support ticket for this issue? If so, could you let us know the ticket number?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #15 cPanelMichael, May 21, 2013
  16. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    49
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    I never did open up a support ticket, and for some reason, even running in compatibility mode doesn't work after a recent update to cPanel. I just export the data in an uncompressed manner now. If it's not fixed when phpMyAdmin 4.0 is moved into cPanel, I will open a ticket.
     
    #16 BillyS, May 25, 2013
  17. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    The memory requirements can be higher for compressed actions with software such as PHPMyAdmin on CentOS 6.x. I have seen once instance where increasing the "Max cPanel Process Memory" via "WHM Home » Server Configuration » Tweak Settings" resolved a similar issue to what's been reported. I encourage anyone else experiencing this issue to open a support ticket and provide the ticket number here so we can report back any details that we find, and open an internal case if necessary.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #17 cPanelMichael, May 27, 2013
  18. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    119
    Likes Received:
    5
    Trophy Points:
    68
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    Twitter:
    Mine is set to unlimited but still have the issue, I will open a ticket right away
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #18 luigidelgado, May 27, 2013
  19. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Could you let us know the ticket number so we can monitor the issue?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #19 cPanelMichael, May 28, 2013
  20. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    119
    Likes Received:
    5
    Trophy Points:
    68
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes I just PM it to you thank you
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #20 luigidelgado, May 28, 2013
(You must log in or sign up to post here.)
Page 1 of 2
Loading...
Similar Threads - phpMyAdmin export error
  1. mahdy_sharifi

    phpmyadmin slow export and error

    mahdy_sharifi, Aug 12, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    420
    cPanelMichael
    Aug 28, 2018
  2. outpostmm

    phpMyAdmin memory limit

    outpostmm, Nov 12, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    190
    cPanelMichael
    Nov 13, 2018
  3. z3d3m0n

    Temp FTP and phpMyAdmin access for Developer?

    z3d3m0n, Nov 9, 2018, in forum: Security
    Replies:
    1
    Views:
    96
    cPanelLauren
    Nov 12, 2018
  4. elisethechemist

    Reseller has to change password to access phpmyadmin

    elisethechemist, Nov 7, 2018, in forum: Database Discussion
    Replies:
    4
    Views:
    101
    elisethechemist
    Nov 7, 2018
  5. Gareth-AWD

    SOLVED PHPMyAdmin Truncate Table bug

    Gareth-AWD, Nov 7, 2018, in forum: Database Discussion
    Replies:
    4
    Views:
    117
    Gareth-AWD
    Nov 9, 2018

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