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 On 5/23/08, Mike <[EMAIL PROTECTED]> 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 <[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] >>>> > >>>> >>>> >>> >>> >> >> > >