It is seems that "RESET SLAVE" query sholud not be done while replication is working. Slave forget its replication position and cannot continue replication since it tries to do the queries already executed. Do I need to do "SLAVE STOP" before "RESET SLAVE"? Or any other means to delete replication logs during replication?
-- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -----Original Message----- > From: Chung Ha-nyung [mailto:alita@;neowiz.com] > Sent: Monday, October 21, 2002 2:22 PM > To: 'Victoria Reznichenko'; [EMAIL PROTECTED] > Subject: RE: What is relay-bin log? > > > > If all works correctly, can I delete replication logs by > "RESET SLAVE" > safely? > I'd like to configure two servers with two-master scheme, each is the > master of > another. > > -- > Chung Ha-nyung <alita@[neowiz.com|kldp.org]> > Sayclub <http://www.sayclub.com> > NeoWiz <http://www.neowiz.com> > > > > -----Original Message----- > > From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] > > Sent: Friday, October 18, 2002 8:01 PM > > To: [EMAIL PROTECTED] > > Subject: re: What is relay-bin log? > > > > > > Chung, > > Thursday, October 17, 2002, 9:48:15 AM, you wrote: > > > > CHn> At the slave server of replication there are log files like > > CHn> environment hostname-relay-bin.xxx. > > > > Yes, these logs are used for replication: > > http://www.mysql.com/doc/en/Replication_SQL.html > > > > CHn> For what these logs and how can I know which one I can > > delete safely? > > > > RESET SLAVE; > > > > > > -- > > For technical support contracts, goto > > https://order.mysql.com/?ref=ma02-010c > > This email is > > sponsored by Ensita.net http://www.ensita.net/ > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > > <___/ www.mysql.com > > > > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
