Mysql Dump

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

mysqldump  -p -h  192.168.1.11 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

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.

http://www.rabbitmq.com/install-rpm.html

wget -O /etc/yum.repos.d/epel-erlang.repo http://repos.fedorapeople.org/repos/peter/erlang/epel-erlang.repo
yum install erlang
rpm –import http://www.rabbitmq.com/rabbitmq-signing-key-public.asc
yum install rabbitmq-server-3.0.1-1.noarch.rpm
cd ..
cd downloads/

wget http://www.rabbitmq.com/releases/rabbitmq-server/v3.0.1/rabbitmq-server-3.0.1-1.noarch.rpm
yum install rabbitmq-server-3.0.1-1.noarch.rpm
/sbin/service rabbitmq-server start