Re: turn a slave back into its own master

[Paul Berry]

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 !!!!
>