On Thu, May 22, 2008 at 9:20 AM, Tom Brown <[EMAIL PROTECTED]> wrote:
> > Hi >> >> I had master-master working fin in dev - i move them to prd now and so >> change the hostnames, on starting i see this error >> >> 080522 11:53:40 mysqld started >> 080522 11:53:40 InnoDB: Started; log sequence number 0 213274351 >> 080522 11:53:40 [ERROR] Failed to open the relay log >> './devnagios01-relay-bin.000003' (relay_log_pos 949012) >> 080522 11:53:40 [ERROR] Could not find target log during relay log >> initialization >> 080522 11:53:40 [ERROR] Failed to initialize the master info structure >> >> in mysql data directory i see this >> >> -rw-rw---- 1 mysql mysql 949012 May 22 11:40 devnagios01-relay-bin.000003 >> -rw-rw---- 1 mysql mysql 34 May 19 16:08 devnagios01-relay-bin.index >> -rw-rw---- 1 mysql mysql 4 May 22 11:53 prdnagios01-relay-bin.000001 >> -rw-rw---- 1 mysql mysql 4 May 22 11:54 prdnagios01-relay-bin.000002 >> -rw-rw---- 1 mysql mysql 68 May 22 11:54 prdnagios01-relay-bin.index >> >> is there a way to 'flush' this or simalar so i can start the slaves again? >> >> > hmm actually on one of the db's i see this > > mysql> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: > Master_Host: 192.168.12.225 > > thats the OLD dev IP and not the prd one - even though i have updated the > master host IP in the my.cnf file. How can i change this value? > I don't think you need to flush your bin logs. CHANGE MASTER TO MASTER HOST = 'hostname'; Look at this for more info at http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html There is a lot more you can add to the statement. > > thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >