i am ok with this mysql> change master to master_host=''; Query OK, 0 rows affected (0.01 sec)
mysql> show slave status\G Empty set (0.01 sec) Saravanan --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote: > From: Paul Berry <[EMAIL PROTECTED]> > Subject: Re: turn a slave back into its own master > To: [EMAIL PROTECTED] > Cc: "MySql" <mysql@lists.mysql.com> > Date: Saturday, January 19, 2008, 6:03 AM > thanks - i think i'm ok because > i get these results > mysql> show slave status; > Empty set (0.00 sec) > > > > On 1/18/08, Saravanan <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > will removing the master.info help instead of > executing change master? > > > > or > > >stop slave; > > >reset master; > > > > > > --- On Sat, 1/19/08, Paul Berry > <[EMAIL PROTECTED]> wrote: > > > > > From: Paul Berry <[EMAIL PROTECTED]> > > > Subject: Re: turn a slave back into its own > master > > > To: "MySql" > <mysql@lists.mysql.com> > > > Date: Saturday, January 19, 2008, 5:31 AM > > > i ended up doing this - it seems to have worked > fine > > > > > > STOP SLAVE; > > > SHOW SLAVE STATUS; > > > CHANGE MASTER TO > > > MASTER_HOST='', > > > MASTER_PORT=0, > > > MASTER_USER='', > > > MASTER_PASSWORD=''; > > > RESET MASTER; > > > > > > > > > > > > On 1/18/08, Paul Berry > <[EMAIL PROTECTED]> > > > wrote: > > > > > > > > hi guys, quick question > > > > > > > > how do i undo a CHANGE MASTER TO command and > make it a > > > master of itself > > > > again? > > > > thanks !!!! > > > > > > > > > > > > > ____________________________________________________________________________________ > > Never miss a thing. Make Yahoo your home page. > > http://www.yahoo.com/r/hs > > ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
