#4025 (ok 4.0.6) gzip export is not actually compressed with mod_deflate

[Isaac Bennetch]

See https://sourceforge.net/p/phpmyadmin/discussion/Help/thread/0dab8571/#c37b, originally reported by user candev.

When attempting to create an export compressed with gzip, and the Apache server is running mod_deflate, the resulting file is not actually compressed (regardless of whether it's saved on the server or downloaded).

This only happens when Apache is running with mod_deflate; if mod_deflate is disabled the gzip works correctly. This only happens with gzip compression.

[Razor7]

Hi, the same here, phpMyAdmin 4.0.3 on ubuntu server 12.04 LTS. Select as gzip export compression but the file size is the same as the database! 30MB uncompressed sql script!!!. Ater download and compression with real gzip, i got only 500kb!

Any workaround?

[candev]

This behaviour is seen back to 3.5.8.1. I guess the workaround would be to disable mod_deflate or use bzip compression.

[Marc Delisle]

See my last message (today) here:
https://sourceforge.net/p/phpmyadmin/bugs/3673

I'm not sure we'll find a solution that works in every case.

[Marc Delisle]

When I tried to fix bug 3673 by adding the detection of mod_deflate, this worked because this user probably has an Apache which applies the deflate to all mime types. I think that a better deflate configuration is like the one in Debian 7 (apply deflate depending on mime types) and we should no longer try to detect mod_deflate (which will reintroduce the bug for this user, unless he improves the deflate config).
Or if mod_deflate is detected, we disable gzip compression in the choices?

[Marc Delisle]

Fix by removing the mod_deflate detection.