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
post_max_size = 150M

I wouldn’t go above 200

Than restart cpanel from the command line:

service cpanel restart

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 tables completely, you can generate a new instance of the tables via:

Code:
/usr/local/cpanel/bin/updateeximstats

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 ———

Test CGI Script

It’s really easy to test your CGI (or a perl script) by adding a test.cgi script with the permissions:  755

Just make sure there is no white space on the top or bottom of the file and the file only has exactly what’s show below. Make sure the name is test.cgi and put in your main folder. Then go to www.your-main-domain.com/test.cgi

#!/usr/bin/perl

# hello.pl -- my first perl script!

print "Content-type: text/html\n\n";

print <<"EOF";
<HTML>

<HEAD>
<TITLE>Hello, world!</TITLE>
</HEAD>

<BODY>
<H1>Hello, world!</H1>
</BODY>

</HTML>
EOF

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.