I think you should check the error with perror at first. On Sat, May 24, 2008 at 12:46 AM, Mike <[EMAIL PROTECTED]> wrote:
> On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar <[EMAIL PROTECTED]> 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 <[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] > >>>>> > > >>>>> > >>>>> > >>>> > >>>> > >>> > >>> > >> > >> > > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn