(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]
