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:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2008 12:58 AM To: Krishna Chandra Prajapati Cc: Jesse; mysql@lists.mysql.com 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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] >> >> >> > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
