Enabling zipped mysql dump support for phpmyadmin

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

[wpfmb type=’error’ theme=2]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[/wpfmb]

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.