Tutorial How to increase the maximum upload limit in PHPMyAdmin

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.

Overview
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:


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: WHM Home »Server Configuration »Tweak Settings.
3. Click on the PHP tab.
4. For the "cPanel PHP max upload size" option, increase the upload limit to your desired value. 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. 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:



Questions/Feedback
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.



Admin Note:
=======================================================================
This cPanel staff tutorial is no longer being maintained/updated here. For the most recent/up to date version please go here: How to increase the maximum upload limit in phpMyAdmin