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
update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); Make sure and remove the  tab when entering the variable. If you know how to do this database wide without needing the table listed please post in the comments.
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.
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