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

Removing the eximstats file

You can modify the following option in “WHM Home » Server Configuration » Tweak Settings” under the “Stats and Logs” tab: “The interval, in days, to retain Exim stats in the database” Reducing this value will decrease the amount of data that is stored in the Eximstats database.  If you decide to drop the eximstats… Continue reading Removing the eximstats file

How to back up and restore a MYSQL database by command line

Here is how to back up and restore a MYSQL database by command line Back up a MYSQL database: Code: ——— mysqldump –opt -Q -u dwhs_dwhs -p dwhs_wrdprss*A* > /home/dwhs/workroom/dwhs_wrdprss1.sql ——— Restore a MYSQL database: Code: ——— mysql -u dwhs_dwhs -p dwhs_wrdprss*B* < /home/dwhs/workroom/dwhs_wrdprss1.sql ———

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.