Enable Zipped MySql Dump Support for cPanel PhpMyAdmin

Learn how to enable zipped MySql dump support for cPanel PhpMyAdmin. A step by step tutorial for self learners.

If you are trying to import a zipped mysql database in cPanel you may receive the following error:

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 means that you need recompile the cPanel version of PHP to include ZIP support.

• SSH into your server using your SSH client (we recommend Putty)
• Type: nano /var/cpanel/easy/apache/profile/makecpphp.profile.yaml
• Scroll down and find:

Cpanel::Easy::PHP5::Zip: 0

Change it to

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

(Note: It may already be set to 1, in which case just exit the file by pressing ctrl-X)

• Save the file and exit Nano.
• Type: /scripts/makecpphp

The script will recompile the cPanel version of PHP with zip support included. You should now be able to upload zipped sql dumps through PHPMyAdmin within cPanel.