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