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 <[EMAIL PROTECTED]> wrote: > > > > On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> 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 <[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] >> > >> >> > >
