How to Increase the Maximum Upload Limit in phpMyAdmin from cPanel

How can the maximum upload limit in phpMyAdmin from cPanel be increased?

When dealing with databases hosted in a cPanel environment, you might find yourself hitting upload limits within phpMyAdmin that don’t allow you to import bigger SQL files. The not-so-welcome “Maximum upload size exceeded” message can be a nuisance, but cPanel has a few solutions to boost these limits without needing direct access to the server. This tutorial takes you through step by step how to boost phpMyAdmin’s upload limits using your WHM control panel.

Prerequisites

• Before you start, make sure you have:Root or admin access to WHM
  New account information (domain name, username, etc.)
• Enough server resources to create a new account
  Knowledge of the PHP Limits Impacted by phpMyAdmin
• A number of PHP config values interact and set your maximum upload size:

Understanding the PHP Limits Affecting phpMyAdmin

Several PHP configuration values work together to determine your maximum upload size:

upload_max_filesize:Maximum file size for a single uploaded file

post_max_size:Maximum POST data size (should be bigger than upload_max_filesize)

memory_limit:Maximum memory a script may use

max_execution_time:Maximum time in which a script can be executed before timing out

max_input_time:Maximum amount of time to allow for input data parsing

Step-By-Step Instructions

• Log in to WHM.
• Navigate to “Server Configuration” and click on the “Tweak Settings” option.

• Select PHP TAB

Find the “cPanel PHP max POST size” setting and change it to your desired value.

Note that any value above 2047MB is not permitted. If your import file exceeds 2047MB, you’ll need to use the command line to import the database.

Then, go to “cPanel PHP max upload size” and change it accordingly without exceeding the 2047MB mark.

Finally, after configuring the values, scroll down and click the “Save” button. A web server restart might be necessary for the changes to be applied done.

Congrats you learned how to increase max upload size in cpanel​.