Enabling zipped mysql dump support for phpmyadmin

Posted on by Seemab Saleem

In phpmyadmin, while importing a zipped database you might get a error as follows:

You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration. Enable .zip file import from cPanel phpmyadmin

This error happens generally as there is no zip support allowed for phpmyadmin on the server. To be able to allow the support you can do the following:

This will need reconfiguration of the internal cpanel php installation
Follow the steps given below:

Open the file /var/cpanel/easy/apache/profile/makecpphp.profile.yaml.

/var/cpanel/easy/apache/profile/makecpphp.profile.yaml

Locate for the line which says: Cpanel::Easy::PHP5::Zip: 0

Here 0 indicates the support is disabled. In order to enable the support replace the 0 with 1.

The entry will look as follows:

Cpanel::Easy::PHP5::Zip: 1

Save and quit the editor.

Rebuild PHP with the changes made.

/scripts/makecpphp

This rebuild process may take some time to complete. Once done, try to dump the zipped database in phpmyadmin.

It should now resolve the error.