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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
