Raising the upload limit in phpmyadmin for CPanel

Firs you need to find the phpmyadmin php.ini file. Use this command to find all php.ini files:

find /usr -name php.ini

Then find the path to the php.ini file that is listed in the “phpmyadmin” folder.

Mine was


Next find these two section and change the limit how you want:

upload_max_filesize = 150M
post_max_size = 150M

I wouldn’t go above 200

Than restart cpanel from the command line:

service cpanel restart

mysql find and replace table

How to Find & Replace Data in MySQL

To find a string in a certain field and replace it with another string:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

(Don’t forget to remove the [] bars!) You can run this from root, ssh, or in your phpmyadmin under the MYSQL tab.

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