lt;[EMAIL PROTECTED]> wrote:
From: Paul Berry <[EMAIL PROTECTED]>
Subject: Re: turn a slave back into its own master
To: [EMAIL PROTECTED]
Cc: "MySql"
Date: Saturday, January 19, 2008, 6:03 AM
thanks - i think i'm ok because
i get these results
mysql> show slave status;
n 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/
>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"
> > Date: Saturday, January 19, 2008, 5:31
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
hi guys, quick question
how do i undo a CHANGE MASTER TO command and make it a master of itself
again?
thanks
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