phpMyAdmin doesn't load database import file with unsupported compression (application/gzip)

Question

I upgraded from an older lubutu release to 14, now running PHP 5.5 and phpMyAdmin 4.0.10deb1, I regularly move small MySQL database exports between hosts (700KB gzip, around 7-10MB decompressed SQL).

You attempted to load file with unsupported compression (application/gzip). Either support for it is not implemented or disabled by your configuration.

This was all working swimmingly on the older PHP setup, I'm not sure if it's a mime type thing or a configuration issue.

I can provide detailed phpinfo() dumps, but zlip is there, phar, etc:

Registered PHP Streams  https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip

Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, tls

Registered Stream Filters   zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk

The gzipped sql files aren't corrupt, they decompress and load manually without issue. If there's some configuration setting you can suggest I'll try that out

Answer 1

i had the same problem under different configuration: Ubuntu 16.04 + PHP 7.0 + VirtualMin. The zip library for php7.0 was simply not installed, so this fixed the problem:

apt-get install php7.0-zip

Edit: this works for php 7.0, the command must suit your php version (7.x)

Answer 2

Put the fix from here http://piwigo.org/forum/viewtopic.php?pid=151458

if (extension_loaded('zlib') && !function_exists('gzopen') && function_exists('gzopen64'))
{
  function gzopen($filename, $mode, $use_include_path = 0) {
    return gzopen64($filename, $mode, $use_include_path);
  }
}

in your /etc/phpmyadmin/config.inc.php. Then it will survive an apt-get upgrade.