Re: master master replication - hostname change - slaves fails

[Tom Brown <tom@xxxxxxxx>]

> 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 but this gave me a very similar error - I forget now as i 
reinstalled from scratch.

i now get this error

080522 13:49:34 [ERROR] Slave: Error 'Table 'db' already exists' on 
query. Default database: 'mysql'

which to me is odd as i have the following in my my.cnf

binlog-ignore-db=mysql

so i would have thought it would not try and replicate that db ? 
Although i did not need that in my previous configuration.

Any thoughts ?



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx