Mysql Dump

For export : mysqldump -u root -p  DBNAME  > mybackUP.sql
For import : mysql -u root -p DBNAME  < mybackUP.sql

mysqldump  -p -h DBName > filename.sql

mysqldump –no-data -u root -p  DBNAME  > mybackUP.sql

mysql -u username -p dbname –ignore-table=db.tbname –ignore-table=db.tbname  < C:\wamp\bin\mysql\filename.sql

mysqldump -u username -p dbname –ignore-table=db.tbname –ignore-table=db.tbname >filename.sql

mysqldump -u username -e -q –single-transaction –master-data –databases dbname -p > fulldump.sql

grant replication slave on *.* to ‘user’@’localhost’ identified by ‘pass’;flush privileges;


RabbitMQ is open source message broker software (sometimes called message-oriented middleware) that implements the Advanced Message Queuing Protocol (AMQP). The RabbitMQ server is written in the Erlang programming language and is built on the Open Telecom Platform framework for clustering and failover. Client libraries to interface with the broker are available for all major programming languages.

wget -O /etc/yum.repos.d/epel-erlang.repo
yum install erlang
rpm –import
yum install rabbitmq-server-3.0.1-1.noarch.rpm
cd ..
cd downloads/

yum install rabbitmq-server-3.0.1-1.noarch.rpm
/sbin/service rabbitmq-server start