Add additional option to my.cnf [mysqld] relay-log-purge=1
On Mon, Aug 11, 2008 at 2:21 AM, Brown, Charles <[EMAIL PROTECTED]> wrote: > Here is what I'm getting > > mysql> change master to master_host = 'naxbmisq01.bmi.com', master_user > = 'repl', master_password = 'repl'; > ERROR 1201 (HY000): Could not initialize master info structure; more > error messages can be found in the MySQL error log > mysql> reset slave; > Query OK, 0 rows affected (0.00 sec) > > mysql> change master to master_host = 'naxbmisq01.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 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 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 have already been > used. > > > What's the command or setting for this action? > > --David. > ******************************************** > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified > that any dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase > all copies of the message and its attachments and notify us > immediately. > > Thank you. > ******************************************** > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn