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

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

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

Convert Database ENGINE from InnoDB to MyISAM

In order to change the Database ENGINE from InnoDB to MyISAM you may follow these instructions. Take the backup of the Database mysqldump cpaneluser_databasename > cpaneluser_databasename.sql Once you secure the Database you may create a file called DBlist.txt at...