On Thu, May 22, 2008 at 10:00 AM, Tom Brown <[EMAIL PROTECTED]> wrote:
> > >> 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. Don't jump the gun to reinstall so fast, your last spot was easier to fix. > > > 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 ? > > Well if your master ever fails and you make the slave your new mater you will be missing your mysql database. User mostly will be missing, which might not be a big thing in your situation. Are there any other logs before and after? Mike
