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 /usr/local/cpanel/3rdparty/etc/phpmyadmin Next find these two section and change the limit how you want: upload_max_filesize = 150M AND… Continue reading Raising the upload limit in phpmyadmin for CPanel

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… Continue reading How to increase upload limit for PhpMyAdmin on a Cpanel server