How to Increase the Maximum Upload Limit in phpMyAdmin from cPanel
How can the maximum upload limit in phpMyAdmin from cPanel be increased?
When working with databases in a cPanel hosting environment, you may encounter upload limitations in phpMyAdmin that prevent you from importing larger SQL files. The dreaded “Maximum upload size exceeded” error can be frustrating, but fortunately, cPanel provides several ways to increase these limits without direct server access. This guide walks you through the step-by-step process of increasing phpMyAdmin’s upload limits through your WHM interface.
Prerequisites
Before you begin, ensure you have:
- Root or administrative access to WHM
- Necessary information for the new account (domain name, username, etc.)
- Sufficient server resources to create a new account
Understanding the PHP Limits Affecting phpMyAdmin
Several PHP configuration values work together to determine your maximum upload size:
upload_max_filesize:Maximum size of individual uploaded files
post_max_size:Maximum size of POST data (should be larger than upload_max_filesize)
memory_limit:Maximum memory a script can use
max_execution_time:Maximum time a script can run before timing out
max_input_time:Maximum time allowed for parsing input data
Step-By-Step Instructions
- Log in to WHM.
- Go to “Server Configuration” and then click on the “Tweak Settings” option.
Select PHP TAB
Locate the “cPanel PHP max POST size” setting and update it to your preferred 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.
- Next, navigate to the “cPanel PHP max upload size” setting and adjust it as needed, ensuring it does not exceed the 2047MB limit.
After configuring the values, scroll down and click the “Save” button. Note that a web server restart might be required for the changes to apply successfully.
