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]