RE: Stopping using a server as a slave

2008-11-25 Thread Rolando Edwards
AIL 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 > &

Re: Stopping using a server as a slave

2008-11-25 Thread Claudio Nanni
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 no

Re: Stopping using a server as a slave

2008-11-25 Thread Krishna Chandra Prajapati
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

Re: Stopping using a server as a slave

2008-11-25 Thread Amit Sharma
Hi Jesse, Just add 'skip-slave-start' to your configuration file, restart & there you go. Best regards, Amit Sharma 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 s