Enabling zipped mysql dump support for phpmyadmin
In phpmyadmin, while imporing a zipped database dump you might get an 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 occurs basically as there is no zip support enabled for phpmyadmin on the server. In order to enable the suppport you can do the following:
This will need reconfiguration of the internal cpanel php installation
Follow the steps given below:
1. Open the file /var/cpanel/easy/apache/profile/makecpphp.profile.yaml.
[root@server~]# vi /var/cpanel/easy/apache/profile/makecpphp.profile.yaml
2. 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:
3) Save and quit the editor.
4)Rebuild PHP with the changes made.
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.