If phpMyAdmin is not working properly on your cPanel server, like blank phpmyadmin page. In such case, you should consider updating phpmyadmin.
Login to your server via SSH as root user. Now run following command:
/usr/local/cpanel/bin/updatephpmyadmin --force
Note:
This works on a cPanel server / VPS only.
When you try to add / create an addon domain in cPanel, but you get following error message:
The server administrator has disable creation of parked/addon domains that resolve to other servers. This is done for security reason.
Login in root WHM and navigate to:
And set this option to ON.
Done!!!
It is highly recommended to keep Allow Remote Domains to Off for security reason. So, after adding your addon domain, set this option back to Off
If you don’t have root access of server, please contact your hosting provider. Send them your addon domain, and your cPanel username. They should add domain name in your account.
When you run cPanel Security Advisor, and if you get kernel out of date warning message, you need to update server kernel. The warning message may be something like below:
Updating from WHM may not solve this problem. This tutorial explains how to update kernel and solve this warning.
Login to your server as root via SSH and run following command:
yum update
Accept kernel upgrade when asked. Reboot server after update.
Done!!
This tutorial explains how you can optimize your cPanel powered website by compressing content.
Apache will automatically compress content when that content is requested by visitors. And will send compressed content to browser. Thus it will reduce load time and optimize your website. This feature is available in Apache 2.0 and later.
Login in cPanel of your website and navigate to:
Here you can enable this feature. By default it is disabled.
This features requires mod_deflate Ask your hosting provider to enable/ install mod_deflate on the server.
If you are selling shared hosting or reseller hosting on your server, you must set a limit of number of mails that a website / domain / account can send per hour.
You can set this limit easily on a cPanel server. Please follow below steps.
Login in WHM as root user and navigate to:
cPanel offers you to schedule backup and retain backup of server and accounts. But if you need to run backup manually, you can do it from SSH. Login to your server as root via SSH and run following command.
/usr/local/cpanel/bin/backup
If the backup is up-to-date, you can force to run backup using below command
/usr/local/cpanel/bin/backup --force
/scripts/cpbackup
If the backup is up-to-date and you wish to run backups anyway, use:
/usr/local/cpanel/scripts/cpbackup --force
cPanel default backup system may fail to create and save backup of your server and send you following message:
Any old backup process is still running in background on the server.
Login to your server as root via SSH and execute following command
/usr/local/cpanel/bin/backup --force
Most probably it will show you following type message:
Backup process currently running. Pid: 5378 Backup log file: /usr/local/cpanel/logs/cpbackup/1377934812.log
We need to kill the current running backup process. Note the Pid from above and run following command. Change xxxx to Pid number that you have got from above.
kill -9 xxxx
cPanel backup should now run normally. You can force to start a new fresh backup process using below command:
/usr/local/cpanel/bin/backup --force
This tutorial explains how you can change or move MySQL /tmp directory to a new location on a server / VPS. Login as root to your server via SSH.
nano /etc/my.cnf
tmpdir=/home/mysqltmp
To save file press: Ctrl + O
To exit from nano editor press: Ctrl + X
This will set new location of MySQL tmp to /home/mysqltmp. You may change to any different location.
mkdir /home/mysqltmp chmod 1777 /home/mysqltmp
/etc/init.d/mysql restart
mysqladmin var | grep tmpdir
This should show following return.
| slave_load_tmpdir | /home/mysqltmp | tmpdir | /home/mysqltmp
Done!!
Many server / VPS have very small /tmp partition like 500 MB. It is recommended to have /tmp partition of minimum 2GB.
If you server is facing issue of /tmp partition filling-up quickly, here is how you can increase its size.
This tutorials explains how easily you can increase size of /tmp partition on a cPanel server / VPS.
Login as root via SSH to your server, and follow below steps / commands.
Before you start resizing, you should stop cpanel, apache and mysql. Run following command to stop these services
/etc/init.d/cpanel stop /etc/init.d/httpd stop /etc/init.d/mysql stop
umount -l /tmp umount -l /var/tmp
vi /scripts/securetmp
And change value of my $tmpdsksize For making size of /tmp partition to 2GB change its value to 2048000. After making change save this file. It should be like this:
$tmpdsksize = 2048000
rm -fv /usr/tmpDSK /scripts/securetmp
/etc/init.d/httpd start /etc/init.d/mysql start /etc/init.d/cpanel start
Done!!! The /tmp partition on your cPanel server is now of 2GB
By default all MySQL database on a server is saved in /var/lib/mysql directory. If you don’t have enough space left in /var directory or if its filling up quickly, you can move your MySQL directory to /home partition.
Assuming you have enough space in /home partition, follow below steps to move MySQL to a new location in /home/var_mysql directory.
Login in server as root via SSH and run following command:
mysqldump --all-databases | gzip > /home/alldatabases.sql.gz /etc/init.d/mysql stop mkdir /home/var_mysql mv /var/lib/mysql /home/var_mysql chown -R mysql:mysql /home/var_mysql/mysql ln -s /home/var_mysql/mysql /var/lib/mysql /etc/init.d/mysql start
Done!!!
You should now have your MySQL at a new location /home/var_mysql
mysqldump --all-databases | gzip > /home/alldatabases.sql.gz
This will create a full backup of all MySQL database. If anything goes wrong, you can restore all MySQL database using this backup file. Name of this file will be alldatabases.sql.gz and it will be saved in /home directory.
/etc/init.d/mysql stop
This will stop mySQL.
mkdir /home/var_mysql
This will create a new directory var_mysql in /home
mv /var/lib/mysql /home/var_mysql
This will move /var/lib/mysql to /home/var_mysql
chown -R mysql:mysql /home/var_mysql/mysql
This will give ownership of /home/var_mysql/mysql directory to user mysql.
ln -s /home/var_mysql/mysql /var/lib/mysql
This will symlinking the old /var/lib/mysql to the new location.
/etc/init.d/mysql start
This will start the MySQL.
We have create a full MySQL backup in our first step. If anything goes wrong, you will always have the full mysql backup to restore all database. Please refer to below tutorial to restore your databases using the full MySQL backup file.
http://www.lophost.com/tutorials/ssh/how-to-create-and-restore-mysql-backup-of-all-accounts/
