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.
Next find these two section and change the limit how you want:
upload_max_filesize = 150M
post_max_size = 150M
I wouldn’t go above 200
Than restart cpanel from the command line:
service cpanel restart
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:
This simple command will list the inodes used for any group on the server:
repquota -a | head -n5 ; repquota -a | grep username
Just replace where it says “username” with the group or username you want to check.
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 ———
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
# hello.pl -- my first perl script!
print "Content-type: text/html\n\n";
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.