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]

Reply via email to