I believe you would have been ok with stop slave and reset master.
Saravanan wrote:
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
--
B. Keith Murphy
Paragon Consulting Services
http://www.paragon-cs.com
850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
