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] >>>>> > >>>>> >>>>> >>>> >>>> >>> >>> >> >> >