Disable MySQL slave Configuration and Reset Mysql Slave

Wednesday, September 24, 2014

How do I completely disable MySQL replication ?

Reset Mysql Slave :- 

following are steps to reset mysql slave :-

1. >login mysql

2. mysql>check slave status \G;

3. mysql> STOP SLAVE;

4. mysql> RESET SLAVE;
               (Use RESET SLAVE ALL; for MySQL 5.5.16 and later)

5. mysql>exit

6. edit my.cnf file
    vi /etc/my.cnf

7. comment below in my.cnf
     #relay-log=mysqld-relay-bin
     #replicate-do-db=
     #replicate-do-db=
     #server-id=2

8. restart mysql
    /etc/init.d/mysqld restart

0 comments:

About This Blog

Lorem Ipsum

  © Copyright 2009 Linux-HelpLine.Blogspot.com

Back to TOP