Install FFMPEG

Steps To Install FFMPEG   Install rpmforge repo rpm -Uvh http://apt.sw.be/redhat/el5/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.3-1.el5.rf.x86_64.rpm Install dependencies related to the ffmpeg package yum install openjade rpm -Uvh...

MySQL Slow Query Logs

“Slow Query” :-  Slow Query in simple terms can be defined as the query which took long time to get executed.. By default MySQL server is configured to mark the query which takes more then 10 sec to get executed as Slow Query. It is best pratice to log all...

mysqldump with selected tables

Mysql Command to take Dump of Selected Tables in the Mysql Database If you wish to take dump of on few tables such as table1, table2 & table3 use the command mysqldump -u mysqlusername -p databasename table1 table2 table3 > databasebackup.sql If you wish to...

Shell Script To Take Backup of the Database

First create a script under the home directory of the account lets say /var/www/vhosts/yourdomain.com/mysqldatabasebackupscript.sh In this case I am taking the example of domain hosted on the Linux Plesk Server, please change the paths accordingly for cPanel servers...

PostgreSQL tutorial

PostgreSQL or Postgres is an object-relational database management system (ORDBMS). The PostgreSQL tutorial is basically a list of the few basic commands which can help you manage the Postgres database with ease. To check the pgsql root user password ( On cPanel...

FTP Icons Missing From the cPanel

May a times due to the latest cPanel update, we face the issue that FTP Icons from the cPanel gets disappeared, the work around for this issue is to disable the FTP server and again enabling it from the FTP Server Selection option in the WHM. To perform the same task...

Custom php.ini on FCGI server

To configure the custom php environment (php.ini) settings for the accounts on the server running FCGI following steps are needed to be followed. Access the cgi-bin location in the root of your website cd /home/cpanel-user/public-html/cgi-bin Copy the php.ini to it cp...