Replication is a complicated process.I can't see what you do and what happened for your computer. From you description,i think you maybe save some old file in your entironment and some configer parmater point to it. So,the best way is sending you actions to me step by step and we will analyse what problem happened. The simple way is re-install your salve and recover mysql data and rebuild Replication environment. ----- Original Message ----- From: "Ananda Kumar" <[EMAIL PROTECTED]> To: "Moon's Father" <[EMAIL PROTECTED]> Cc: "Mike" <[EMAIL PROTECTED]>; "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>; "MYSQL General List" <mysql@lists.mysql.com> Sent: Monday, May 26, 2008 1:03 PM Subject: Re: error while starting replication for the first time
> 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 >
