Thanks,
I've removed these files. Also, there are a BUNCH of files named
"webserver2-relay-bin.{some#}" in the data folder. Can I delete all of
these (including the .index file)?
Thanks,
Jesse
----- Original Message -----
From: "Brown, Charles" <[EMAIL PROTECTED]>
To: "Michael Dykman" <[EMAIL PROTECTED]>; "Gerald L. Clark"
<[EMAIL PROTECTED]>
Cc: "Jesse" <[EMAIL PROTECTED]>; "MySQL List" <mysql@lists.mysql.com>
Sent: Tuesday, April 24, 2007 4:31 PM
Subject: RE: Stopping Replication
(Read ref manual: 6.4)
Here's the best kept secret:
The Slave has two files called master. info and relay-log.info. The
slave uses these two files to keep track of how much of the master's
binary log it has processed and all pertinent info about the master( i.e
userid, password, hostname) are all documented in the master.info file.
Did you say you would like to stop replication - PERIOD! Delete these
files or use "CHANGE MASTER TO" statement to change replication
parameters.
Why: The contents of master.info overrides some of the server options
specified on the command line or in my.cnf. (Read ref manual: 6.4)
-----Original Message-----
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 2:35 PM
To: Gerald L. Clark
Cc: Jesse; MySQL List
Subject: Re: Stopping Replication
you mill also do well to eliminate the master.nfo file from your data
directory.
On 4/24/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote:
Jesse wrote:
> I'm trying to stop replication between two servers that I've got
here.
> I set it up originally, to play with it and see how it works.
However,
> I now want to use these two servers separately.
>
> I have edited the my.ini file on both the server and slave machines,
and
> removed the server-id from them. I have also executed a stop slave
on
> the slave server. However, it appears that when I stop and re-start
the
> server that was the slave, it tries to re-start replication again,
> because I get the error, "Failed to create slave threads" in the
event
log.
>
> What else do I need to do to stop the replication process?
>
> Thanks,
> Jesse
>
You have to remove the master information from the slave's my.ini
file.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
- michael dykman
- [EMAIL PROTECTED]
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.
If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.
Thank you.
********************************************
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
