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.
regards anandkl On 5/23/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: >>> >>> check permissions >>> >>> On Fri, May 23, 2008 at 12:33 PM, Ananda Kumar <[EMAIL PROTECTED]> >>> 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: [EMAIL PROTECTED] >> >> >> >> > > > > -- > 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: [EMAIL PROTECTED] >
