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 Continue Reading
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 Continue Reading
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 Continue Reading