CODEWITHSUNDEEP
mysqldatabasephpmyadminexportcpanel
NightOwl
NightOwl

Reputation: 118

phpMyAdmin 4.0.5 export error bug - anyone know if it is being addressed?

phpMyAdmin has announced that in a few days on Sept 1st 2013 they're closing down their other resources such as mailing list and forums and are deferring us to use StackOverflow / StackExchange.

I provide general support at a small cPanel hosting service and part of my duties include doing frequent DB Exports in phpMyAdmin and also showing hosting customers how to export their databases from phpMyAdmin within their cPanel as a backup tool.

Been working fine for many years and across many servers / cPanel versions / PHP versions / mysQL versions.

But after we recently upgraded to phpMyAdmin 4.0.5 final (we use WHM's EasyApache to keep PHP and other server modules updated regularly) we're encountering an apparent bug and cannot Export databases.

Any attempt to Export a DB over a certain size (haven't determined exactly yet, but seems to be around 20MB) instead of getting the usual download prompt, it simply immediately fails.

If the Export is attempted in FireFox the error looks like this:

Firefox can't find the file at https://example.example.net:2083/cpsess1210889896/3rdparty/phpMyAdmin/export.php

If the Export is attempted in Internet Explorer simply says "The website cannot display the page" and when more info is clicked says:

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.

Since upgrading to 4.0.5 that just started happening with DB's that I've been exporting through phpMyAdmin for years, literally, with no problem before.

I tried raising some memory limits within WHM / cPanel such as the max memory cPanel session can use, but it doesn't help. Also a couple of discussions on the cPanel forums seem to be claiming that this problem stems from a bug in phpMyAdmin, not a problem with cPanel or PHP.

Can anyone shed any more light on this problem?

Is there anyone from phpMyAdmin who knows if this specific issue is being addressed?

Thanks very much for any help or feedback that anyone here is willing to provide. This is putting me in a bit of a jam with our clients.

Just in case it matters here is the general server environment:

cPanel/WHM 11.38.2 (build 6)
Apache 2.2.25
PHP 5.4.18
mySQL 5.5.32-cll
RHEL 5 64bit
running suPHP

EDIT - I forgot to mention that the problem occurs whether doing a straight "Quick" SQL export and/or a "Custom" compressed export (such as a gzip). Either way, quick or compressed we can't export databases larger than around 20MB.

UPDATE / FIX - Marc Delisle's code changes in phpMyAdmin 4.0.6 fixes this bug, and after cPanel 11.38.2.7 "Release" came out recently it has resolved the issues on my servers. Thank you Marc and the PMA team!

Upvotes: 3

Views: 3034

Answers (4)

ClaudioC
ClaudioC

Reputation: 1545

In my case whas the size of the database, when i export all the tables (40MB) it return the error, but if i choose to get the database as a ZIP it works perfectly ;)

Upvotes: 0

NightOwl
NightOwl

Reputation: 118

Good news for cPanel users who have been affected by this bug.

I was reading the cPanel Change Log and noticed that they are including PMA update to version 4.0.6 (which has Marc Delisle's fix) in the upcoming cPanel 11.38.2.7 update.

That means for most of WHM/cPanel runners the problem will be resolved likely by end of next week.

Upvotes: 1

Marc Delisle
Marc Delisle

Reputation: 9007

Here is a fix I propose for the upcoming 4.0.6-rc2, please confirm: https://github.com/phpmyadmin/phpmyadmin/commit/5298602f8edb4475fce5d299532c7780e0e314a5.patch

Upvotes: 2

Isaac Bennetch
Isaac Bennetch

Reputation: 12462

Possibly related to https://sourceforge.net/p/phpmyadmin/bugs/4046/

Does your webserver error log contain any hints?

Upvotes: 4

Related Questions