[Case 75085] phpMyAdmin Export

rcann

Registered
Mar 28, 2003
3
0
151
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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.
 

brunomenoli

Active Member
Sep 2, 2005
27
0
151
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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.
 

brunomenoli

Active Member
Sep 2, 2005
27
0
151
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
 

rcann

Registered
Mar 28, 2003
3
0
151
New Jersey
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.
Hi Michael,

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

rcann

Registered
Mar 28, 2003
3
0
151
New Jersey
Hi Michael,

Thanks for the reply. The one I was trying is 56M. Regards.
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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.
 

dannette

Member
Apr 27, 2010
13
2
53
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.
 

Lor

Well-Known Member
Apr 29, 2005
60
0
156
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?
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
I have the same problem when you fix this problem?
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.
 

dmacleo

Active Member
Jan 28, 2012
44
0
56
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.
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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.

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
You can not downgrade to cPanel 11.38 after you have upgraded to cPanel 11.40 (11.39 development build).

Thank you.