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?
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]