Note: Importing large databases via the command line is a faster and more reliable alternative to increasing the maximum upload limit for phpMyAdmin. Click here to learn how to import databases on the command line.
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:
Code: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.
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:
- Login to WHM as the root user.
- Navigate to: WHM Home »Server Configuration »Tweak Settings.
- Click on the PHP tab.
- For the "cPanel PHP max upload size" option, increase the upload limit to your desired value. Values higher than 2047MB are not permitted.
- For the "cPanel PHP max POST size" option, increase the POST value to the same or higher. Values higher than 2047MB are not permitted.
- Click Save.
Feel free to click on the Discussion tab to let us know if you have any trouble with the instructions in this tutorial, or have additional questions and feedback.
Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!