How to increase upload limit for PhpMyAdmin on a Cpanel server

By default, PhpMyAdmin in a Cpanel server imposes an upload limit of 50MB. So importing a SQL file larger than 50MB may time out.

Cpanel PhpMyAdmin uses the php.ini file /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini. To increase upload limit, change values of upload_max_filesize and post_max_size in this php.ini file. Typically, you may set value of post_max_size to twice the value of upload_max_filesize. For example, to import SQL files up to 250MB size, set upload_max_filesize to 250MB and post_max_size to 500MB. You may also want to change values of max_execution_time and memory_limit.

Typical values may be:

upload_max_filesize = 250MB
post_max_size = 500MB
memory_limit = 512MB
max_execution_time = 3600

  • 2421 Users Found This Useful
Was this answer helpful?

Related Articles

How to enable gzip or deflate globally in cPanel / WHM

This will be a quick one folks.  The Apache module mod_deflate helps in reducing the size of the...

PCI Compliance in cPanel

PCI scans will often fail for weak SSL ciphers and older protocols. In order to disable older...

Add a MySQL Database in cPanel

The following article explains how to add a MySQL database in cPanel. You can use cPanel's...

How to find the correct path to the working php.ini file in WHM cPanel

run # php -i | grep php.ini at the command line. This will output the path to the php.ini file...

WHM SSH Reset

If for some reason you become locked out of SSH due to a misconfiguration, you may be able to...