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...