Menu
▾
▴
#2124 (ok 2.9.0) Cannot export compressed SQL
I am using the following:
phpMyAdmin 2.8.0.3
Apache 2.0.40
PHP 4.2.2
MySQL 3.23.58
I cannot export any compressed SQL using SSL. I'm not
sure if not using SSL will work, but I don't want to
enter my password unsecured. I've tried exporting ZIP,
GZ, and BZIP and none work. All that is exported is a
192 byte compressed file (zip, gz, bz) and when I try
to open it in WinRAR it says "c:\dbname.sql.gz The
archive is either in unknown format or damaged."
Exporting just a plain text .sql file works though.
I've had this problem since version 2.7.x at least.
Discussion
renamed exported gzip file
Logged In: YES
user_id=1510647
Forgot to mention I tried to export in both IE 6 SP2 and
Firefox 1.0.7
Logged In: YES
user_id=192186
You server ran out of memory, increasing might help. Content
of your file:
<br />
<b>Fatal error</b>: Allowed memory size of 8388608 bytes
exhausted (tried to allocate 4592468 bytes) in
<b>/home/fabuloussavings/apps/phpmyadmin/export.php</b> on
line <b>85</b><br />
Moving to support requests.
Do you have enabled $cfg['CompressOnFly']?
Logged In: YES
user_id=1510647
I have $cfg['CompressOnFly'] enabled. I tried setting the
value to FALSE in my config.inc.php as well which didn't
work either.
I also tried increasing the memory limit to 10MB from 8MB
under "Resource Limits" in php.ini, restarted Apache, but
still no luck. Is that the right place to increase the
memory available?
Logged In: YES
user_id=192186
This is right place, however you will probably need much
more (compression wanted about 13MB).
Logged In: YES
user_id=1510647
I increased the limit to 16MB which did the trick for one
database which is 5.5MB in size. I have another db around
120MB though. I'm not sure how to go about handling that one
as I'll probably need 200MB+ memory. What would you
recommend nijel?
Logged In: YES
user_id=192186
Well you should not need that much memory. phpMyAdmin should
addapt to allowed memory limit.
Only thing that could break it which comes to my mind now is
output buffering in php or some PHP accelerator/cache.
Logged In: YES
user_id=1510647
Well with the limit at 16MB, I can't export the 120MB db
compressed. I guess I'll have to live with exporting a plain
sql text file?
Logged In: YES
user_id=192186
gzip and bzip2 exports should work. zip will not.
Do you have enabled output buffering in php? Any PHP
cache/optimalizator in effect?
Logged In: YES
user_id=1510647
I check in my php.ini file and "output_buffering = Off." I'm
not sure if there are any PHP cache/optimization being used.
I believe it's a standard PHP installation. We're running
Redhat 9 kernel ver 2.4.20-30.9.
Logged In: YES
user_id=192186
Can you please change following line in export.php
$memory_limit *= 2/3;
to
$memory_limit /= 3;
and retry? Thanks.
Logged In: YES
user_id=1510647
I changed the line in export.php about the memory limit, but
I'm still having trouble exporting the large db compressed
in gzip, bzip and zip (the old 192 byte file).
Logged In: YES
user_id=192186
Could you addd echo $memory_limit; at same place? It should
then print limit (to that file). It looks like it is too big.
Logged In: YES
user_id=1510647
Ok here's the output from the browser:
5092405.3333333
Warning: Cannot modify header information - headers already
sent by (output started at
/home/*****/apps/phpmyadmin/export.php:206) in
/home/*****/apps/phpmyadmin/export.php on line 219
Fatal error: Allowed memory size of 16777216 bytes exhausted
(tried to allocate 5102626 bytes) in
/home/*****/apps/phpmyadmin/export.php on line 85
Logged In: YES
user_id=192186
Can you post here structure of that table?
Logged In: YES
user_id=1510647
I'm trying to export all the tables (except for one which is
89MB) from one database. Which structure(s) would you like?
Logged In: YES
user_id=192186
Well all won't hurt ;-). I just want to reproduce your
conditions on my server so that I can test why does not
memory limit detection work.
Logged In: YES
user_id=1510647
Ok I uploaded the table structures