cPanel KnowledgeBase and Troubleshooting, cPanel Server Fixes and Tutorials

There are many options available to Rsync and SCP over non-standard ssh port and key files. Here is the simple example to backup your files and configure with Cron jobs. Rsync is a great tool that allows you to transfer and synchronize data between servers. The command can be used over SSH which encrypts the connection. […]

We can backup our databases using different methods, Here is the shell script used for automatic backup MySQL databases using mysqldump in your cpanel server. The following instruction can be used to backup any database. The only requirement is that you are using a Linux server to host your files and mysql user privileges. Use this Database Automatic […]

If your server is hacked or stolen your accounts password, you can use the following script to change all the cpanel accounts password. Change password via WHM and scripts. WHM >> Account Functions >> Force Password Change then Select All, then Submit   Change multiple accounts password via the following script /scripts/realchpass The syntax is […]

MySQL Performance Tuning Shell Script, This script takes information from “SHOW STATUS LIKE…” and “SHOW VARIABLES LIKE…” then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and above. In your huge traffic cPanel server you can use the following MySQL performance tuning script to optimize […]

Simple Server load alerts shell script to monitor your server load average, Free Memory and Swap status, Disk space information. etc., Please make sure this script will not cause extra load average on your cpanel server. This shell script will send alert to your email account when the server load goes more than 10.   […]

You will get this error during cpanel account transfer time or with cpanel package account script. ERROR: This RRD was created on another architecture If your old machine was 32bit arch with 32bit OS, and the new machine is 64bit with 64bit OS. then you can use rrddump and rrdrestore one can transfer RRD between […]

We can use various methods to change database engine. In order to convert Database ENGINE from InnoDB to MyISAM use the following methods and shell scripts. First you should take all the databases backup. root@serv [~]#mysqldump DBname > DBBacupname.sql Method : 1 Once you secure the Database you may create a file called DBlist.txt and […]

c99 Shell Scripts are one of the main headache for almost all cPanel server administrators even though they use mod_security and all. The c99 php (Hypertext Preprocessor) shell script is an awesome piece of hacking script. The only limitation of it being that it needs an unsecured uploader in order to get it uploaded and […]

Mysqlmymonlite Stats and Monitoring process free tool, Bash shell script tool used to gather stats for Apache, Nginx, litespeed web server and MySQL servers. Useful for troubleshooting & diagnostics and monitoring of server stats. mysqlmymonlite.sh is a MySQL optimization tool – a lite version of more extensive featured mysqlmymon.sh – a MySQL and system monitoring […]

Clear cached memory on cpanel server By default the Linux OS is very efficient memory management process that should be freeing any cached memory on the machine that it is being run on. However when it comes to Cached memory the Linux OS may at times decide that the Cached memory is being used and […]