Hi All, The issue has been solved, we removed relay-log.index files which was refering to the old relay-log file. After this the CHANGE MASTER worked and replication is going on fine.
regards anandkl On 5/24/08, Moon's Father <[EMAIL PROTECTED]> wrote: > > 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
