[Case 75085] phpMyAdmin Export

[rcann]

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]

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.

 

[brunomenoli]

Same problem here, database with 47 MB Two servers with cpanel with problems

 

[cPanelMichael]

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]

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]

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]

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]

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]

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

 

[brunomenoli]

Some Update?

 

[cPanelMichael]

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:

mysqldump database_name > /path/to/exported_database.sql

Thank you.

 

[dannette]

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.

 

[Aita]

I have experineced the same issue, the solution was as posted in
http://forums.cpanel.net/f5/phpmyadmin-export-error-331482-p2.html

To manualy edit
/usr/local/cpanel/3rdparty/php/53/etc/phpmyadmin/php.ini
and increase memory_limit from 128M to 256M (or more depending on how mutch memory was asked for)

 

[AirHost]

I have experineced the same issue, the solution was as posted in
http://forums.cpanel.net/f5/phpmyadmin-export-error-331482-p2.html

To manualy edit
/usr/local/cpanel/3rdparty/php/53/etc/phpmyadmin/php.ini
and increase memory_limit from 128M to 256M (or more depending on how mutch memory was asked for)

I've done that and it doesn't fix it.

 

[Lor]

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 ...

How to downgrade phpmyadmin to previously versions?

 

[nrm]

I have the same problem when you fix this problem?

 

[cPanelMichael]

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]

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]

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.

 

[SigmaWeb]

A resolution for this case is scheduled for inclusion with cPanel version 11.38.2.3.

Thank you.

Hi,
I still experience the issue even in 11.38.2.3 with the new phpmyadmin 4.0.5

Thanks