mysqldump -uusername -ppassword -c -e –default-character-set=utf8 –single-transaction –skip-set-charset –add-drop-database -B dbname > dump.sql cp dump.sql dump-fixed.sql vim dump-fixed.sql :%s/DEFAULT CHARACTER SET latin1/DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci/ :%s/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/ :wq mysql -uusername -ppassword < dump-fixed.sql

use the below command in Mysql 

ALTER DATABASE mydatabasename charset=utf8;

How to fix the 500 error on roundcube

/usr/local/cpanel/bin/update-roundcube –force

How to install postfix on Ubuntu

sudo apt-get install postfix sudo dpkg-reconfigure postfix 
sudo postconf -e 'home_mailbox = Maildir/'   sudo /etc/init.d/postfix restart 
sudo apt-get install dovecot-common 
sudo apt-get install dovecot-imapd 

sudo apt-get install dovecot-pop3d 

sudo useradd -d /home/testuser -m testuser

sudo passwd testuser

How to increase the memory for PHPmyadmin in cPanel server

vi  /usr/local/cpanel/3rdparty/etc/php.ini

and change
upload_max_filesize = 150M
post_max_size = 150M

then run in SSH

/usr/local/cpanel/bin/install_php_inis


service cpanel restart

Getting error in iptables ?

use below steps to get it resolved

yum -y update

iptables -m statistic -h

modprobe -l |grep statistic

rpm -q iptables

wget http://pkgs.org/centos-5-rhel-5/centalt-x86_64/ipt_statistic-0.1-1.el5.x86_64.rpm.html

wget http://pkgs.org/centos-5-rhel-5/centalt-x86_64/ipt_statistic-0.1-1.el5.x86_64.rpm

wget http://centos.alt.ru/repository/centos/5/x86_64/centalt-release-5-3.noarch.rpm

rpm -Uvh centalt-release*rpm