phpMyAdmin – Error: Incorrect format parameter

If you are attempting to import a database or .sql file in PhpMyAdmin and you encounter this error:

phpMyAdmin - Error: Incorrect format parameter

 

This usually indicates that the PHP limits for upload and post_max_size need to be increased.

 

The PHP values for max upload size and max POST size that PhpMyAdmin will use are set inside WHM’s tweak settings. If you encounter the error above, please try checking in the PHP error_log for the respective user you attempted the import from. The PHP error_log will most likely return an error similar to the one below:

PHP Warning:  POST Content-Length of 108671420 bytes exceeds the limit of 57671680 bytes in Unknown on line 0

To resolve this, you must increase the PhpMyAdmin upload limit.

 

Step-By-Step Instructions

  1. 1. Login to WHM as the root user.
  2. 2. Navigate to: WHM Home »Server Configuration »Tweak Settings.
  3. 3. Click on the PHP tab.
  4. 4. For the “cPanel PHP max upload size” option, increase the upload limit to your desired value.
    1. a. Values higher than 2047MB are not permitted.
  5. 5. For the “cPanel PHP max POST size” option, increase the POST value to the same or higher.
    1. a. Values higher than 2047MB are not permitted.
  6. 6. Click Save.

You May Also Like

About the Author: admin

Leave a Reply

Your email address will not be published. Required fields are marked *