If a SQL file is uploaded through phpMyAdmin that exceeds the upload size limit and/or the post size limit, the following error will occur:

phpMyAdmin – Error
Incorrect format parameter

This error is provided because only part of the file was uploaded due to the upload limit which results in a corrupted import.

It is required to increase the cPanel PHP max upload size and cPanel PHP max POST size values in order to increase the maximum upload limit in phpMyAdmin.

The maximum value that these limits can be increased to is 2047M. If your import file is larger than 2047M, you must import the database via the command line.

Step-By-Step Instructions#

1. Login to WHM as the root user.

2. Navigate to “Home / Server Configuration / Tweak Settings” in WHM.

3. Click on the PHP tab.

4. For the “cPanel PHP max upload size” option, increase the upload limit to your desired value.

    a. Values higher than 2047MB are not permitted.

5. For the “cPanel PHP max POST size” option, increase the POST value to the same or higher.

    a. Values higher than 2047MB are not permitted.

6. Click Save.

Once this is done, you’ll see that phpMyAdmin now shows the new maximum upload size on the import screen next to the upload button.