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/[EMAIL PROTECTED]
