STOP SLAVE;
RESET SLAVE;
CHANGE MASTER TO MASTER_HOST='';
RESET SLAVE only clears away relay logs.
CHANGE MASTER TO MASTER_HOST='' will delete the master.info
Replication is eliminated from that point going forward
-----Original Message-----
From: Claudio Nanni [mailto:claudio.nanni@stripped]
Sent: Wednesday, November 26, 2008 12:58 AM
To: Krishna Chandra Prajapati
Cc: Jesse; mysql@stripped
Subject: Re: Stopping using a server as a slave
stop slave;
reset slave;
Krishna Chandra Prajapati wrote:
> stop slave;
> reset slave;
> restart mysql server
>
> On Tue, Nov 25, 2008 at 7:12 PM, Jesse <jc@stripped> wrote:
>
>
>> I have a server that I've been using as a MySQL Slave for a while now. I
>> want to change it over to a regular server now. I could simply stop the
>> slave (STOP SLAVE), however, I'm concerned that if I re-boot the server,
>> then it'll re-start the slave. What else do I need to do to stop using a
>> server as a slave?
>>
>> Thanks,
>> Jesse
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
