Yes, I did so... I will check the other configuration.
Thanks, Kenji On 8/2/06, Dilipkumar <[EMAIL PROTECTED]> wrote:
Hi, First reset slave and then change master to script run it. Thanks & Regards Dilipkumar ----- Original Message ----- From: "Kenji HIROHAMA" <[EMAIL PROTECTED]> To: "Dilipkumar" <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Wednesday, August 02, 2006 3:29 PM Subject: Re: Relay Log Lost on Slave > Hi Dilipkumar, > > I checked the output of show slave status, and memorize; > > RELAY_MASTER_LOG_FILE, and EXEC_MASTER_LOG_POS. > > Then, > > change master to > master_log_file='xx, > master_log_pos=xx; > > However, still I get the same error message. > > Umm..... > > Kenji > > > On 8/2/06, Dilipkumar <[EMAIL PROTECTED]> wrote: >> Hi, >> >> If you relay log is lost try out the this :- >> >> >> Run the Change Master Position script, See the log output from where did >> the >> replication stopped. >> So you can start your replication. >> >> Thanks & Regards >> Dilipkumar >> ----- Original Message ----- >> From: "Kenji HIROHAMA" <[EMAIL PROTECTED]> >> To: <mysql@lists.mysql.com> >> Sent: Wednesday, August 02, 2006 9:36 AM >> Subject: Relay Log Lost on Slave >> >> >> > Hi, >> > >> > Under my replication environment, what should I do if I lose the >> > current relay-log file on slave side? >> > >> > 1. one master and one slave replication is working >> > 2. stop the master and the slave >> > 3. remove the current relay log file manually >> > 4. I can't start replication with "start slave" command >> > the error message is; >> > "ERROR 29 (HY000): File 'xxx-relay-bin.000025' not found (Errcode: 2)" >> > >> > Should I sync the data manually and start replication from the >> > beginning? >> > >> > Thanks, >> > >> > -- >> > [EMAIL PROTECTED] >> > Kenji Hirohama >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: >> > http://lists.mysql.com/[EMAIL PROTECTED] >> > >> >> ********** DISCLAIMER ********** >> Information contained and transmitted by this E-MAIL is proprietary to >> Sify Limited and is intended for use only by the individual or entity to >> which it is addressed, and may contain information that is privileged, >> confidential or exempt from disclosure under applicable law. If this is a >> forwarded message, the content of this E-MAIL may not have been sent with >> the authority of the Company. If you are not the intended recipient, an >> agent of the intended recipient or a person responsible for delivering >> the >> information to the named recipient, you are notified that any use, >> distribution, transmission, printing, copying or dissemination of this >> information in any way or in any manner is strictly prohibited. If you >> have >> received this communication in error, please delete this mail & notify us >> immediately at [EMAIL PROTECTED] >> >> >> Watch the latest updates on Mumbai, with video coverage of news, events, >> Bollywood, live darshan from Siddhivinayak temple and more, only on >> www.mumbailive.in >> >> Watch the hottest videos from Bollywood, Fashion, News and more only on >> www.sifymax.com >> >> > > > -- > [EMAIL PROTECTED] > Kenji Hirohama > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] >
-- [EMAIL PROTECTED] Kenji Hirohama -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
