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 <[EMAIL PROTECTED]> 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 <[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] >>> > >>> >>> >> >> >
