Ananda, The answer to your question is very simple actually, but there is some subtleties that you need to think of.
To stop the slave from getting replication data from the master just issue a "stop slave" command. I would also recommend that you run a "reset master" command in addition. This will reset the master server information to empty (not pointing anywhere). The reason why it is subtle is that you need to know what state you want your data in. When you issue the stop slave command it breaks the replication with the master with your data on the old slave basically the same as the master. Is that what you really want? If not, you need to take other measures to get your data in the state you want before bringing it online as a standalone server. Hope that helps. Keith What data do you want on the new master? ----- Original Message ----- From: "Ananda Kumar" <[EMAIL PROTECTED]> To: "MySql" <mysql@lists.mysql.com> Sent: Thursday, August 30, 2007 3:37:48 AM (GMT-0500) America/New_York Subject: make a slave db a master db Hi All, We have one master and two slave dbs. Now we want one of the slaves to work as a stand alone master db, so what are the steps that i need to take to make one of the slaves as a stand alone master db. regards anandkl -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://www.paragon-cs.com/wordpress (o) 919-433-0786 (c) 850-637-3877