Re: error while starting replication for the first time

[Mike <lunarblu@xxxxxxxxx>]

On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar <anandkl@xxxxxxxxx> wrote:

> Hi Mike,
> Since i have done a fresh backup from master (with master db down), and
> copied over the same to slave. Then why is the slaving looking for old
> relay-log. I also did the "RESET SLAVE", bit still getting error.
>
> I am wondering, why is the slave looking for old relay-logs
>

Your my.cnf might have relaylog info in it.
You might have a master.info or relay log files in your mysql directory.

The slave does need relay logs to replicate.   So if you keep use RESET
MASTER after you backup the mysql then you backup is worthless.

Tell me the steps you are using?



>
> On 5/23/08, Mike <lunarblu@xxxxxxxxx> wrote:
>>
>> Ok, since you do not have the bin log you need to start over again with
>> the replication and do either a
>> mysqldump or get the rawdata.  then once you have the data then you can
>> start replication again.
>>
>>
>> http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-mysqldump.html
>>
>> http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-rawdata.html
>>
>> On Fri, May 23, 2008 at 10:37 AM, Ananda Kumar <anandkl@xxxxxxxxx> wrote:
>>
>>> RESET MASTER...delete all the bin logs. Infact i tried this on the slave
>>> as it also a MASTER to itself, but the error kept on coming.
>>>
>>> regards
>>> anandkl
>>>
>>>
>>>   On 5/23/08, Mike <lunarblu@xxxxxxxxx> wrote:
>>>>
>>>>
>>>>
>>>> On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <anandkl@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Files is owned by mysql, but the point is, these relay-log files are
>>>>> not
>>>>> present.
>>>>> Before setting up the slave, i cleaned up all files.
>>>>>
>>>>
>>>> If you want the logs back you could use RESET MASTER .... maybe.
>>>> http://dev.mysql.com/doc/refman/5.0/en/reset-master.html
>>>>
>>>> Let me know. :-)
>>>>
>>>>
>>>>>
>>>>> regards
>>>>> anandkl
>>>>>
>>>>>
>>>>> On 5/23/08, Krishna Chandra Prajapati <prajapatikc@xxxxxxxxx> wrote:
>>>>> >
>>>>> > Please check the ownership of the files copied on the slave.
>>>>> >
>>>>> > Give permissions by chown -R mysql:mysql
>>>>> >
>>>>> > On Fri, May 23, 2008 at 2:47 PM, Ananda Kumar <anandkl@xxxxxxxxx>
>>>>> wrote:
>>>>> >
>>>>> >> Hi Krishna,
>>>>> >> As i said, this is a complete copy from master db to slave.
>>>>> >> I have deleted all old files from slave and setting up from scratch,
>>>>> by
>>>>> >> taking a complete backup from master, copying over to slave and
>>>>> using the
>>>>> >> change master command with BIN LOG and POSITION taken before taking
>>>>> a backup
>>>>> >> copy from master.
>>>>> >>
>>>>> >>
>>>>> >>
>>>>> >>
>>>>> >> On 5/23/08, Krishna Chandra Prajapati <prajapatikc@xxxxxxxxx>
>>>>> wrote:
>>>>> >>>
>>>>> >>> check permissions
>>>>> >>>
>>>>> >>> On Fri, May 23, 2008 at 12:33 PM, Ananda Kumar <anandkl@xxxxxxxxx>
>>>>> >>> wrote:
>>>>> >>>
>>>>> >>>> Hi All,
>>>>> >>>> I shutdown my master, took a db files backup. Copied it over to
>>>>> slave
>>>>> >>>> machine.
>>>>> >>>> I executed "change master" command, then when i start slave "slave
>>>>> >>>> start", i
>>>>> >>>> get the below error. I did "reset slave", but still getting same
>>>>> error,
>>>>> >>>> what
>>>>> >>>> could be the reason, and how to fix it.
>>>>> >>>>
>>>>> >>>> 080522 23:04:05 [ERROR] Failed to open log (file
>>>>> >>>> '/data/mysql-log/relay-log/relay.000791', errno 2)
>>>>> >>>> 080522 23:04:05 [ERROR] Failed to open the relay log 'FIRST'
>>>>> >>>> (relay_log_pos
>>>>> >>>> 4)
>>>>> >>>>
>>>>> >>>> I am using mysql 5.0.41 community version, on debain.
>>>>> >>>>
>>>>> >>>> regards
>>>>> >>>> anandkl
>>>>> >>>>
>>>>> >>>
>>>>> >>>
>>>>> >>>
>>>>> >>> --
>>>>> >>> Krishna Chandra Prajapati
>>>>> >>> MySQL DBA,
>>>>> >>> Ed Ventures e-Learning Pvt.Ltd.
>>>>> >>> 1-8-303/48/15, Sindhi Colony
>>>>> >>> P.G.Road, Secunderabad.
>>>>> >>> Pin Code: 500003
>>>>> >>> Office Number: 040-66489771
>>>>> >>> Mob: 9912924044
>>>>> >>> URL: ed-ventures-online.com
>>>>> >>> Email-id: prajapatikc@xxxxxxxxx
>>>>> >>
>>>>> >>
>>>>> >>
>>>>> >>
>>>>> >
>>>>> >
>>>>> >
>>>>> > --
>>>>> > Krishna Chandra Prajapati
>>>>> > MySQL DBA,
>>>>> > Ed Ventures e-Learning Pvt.Ltd.
>>>>> > 1-8-303/48/15, Sindhi Colony
>>>>> > P.G.Road, Secunderabad.
>>>>> > Pin Code: 500003
>>>>> > Office Number: 040-66489771
>>>>> > Mob: 9912924044
>>>>> > URL: ed-ventures-online.com
>>>>> > Email-id: prajapatikc@xxxxxxxxx
>>>>> >
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>