Re: can some please help me -- REPLICATION

2008-08-11 Thread Moon's Father
bmisq01.bmi.com', master_user > = 'repl', master_password = 'repl'; > ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found > (Errcode: 2) > mysql> > > > > -Original Message----- > From: David Giragosian [mailto:[EMAIL PRO

RE: can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
t; -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your s

RE: can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
Re: You can tell mysql to not keep relay logs that have already been used. What command does this -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On

Re: can some please help me -- REPLICATION

2008-08-10 Thread David Giragosian
On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your slave. If it hasn't run for over a > month then there's not a lot of point in trying to start it up. Even if > you > did start the slave (which seems doubtful) you'd have over a month's worth > of commands t

Re: can some please help me -- REPLICATION

2008-08-10 Thread Jim Lyons
you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that ha

can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not