Live Backups of MySQL Using Replication
Subject:   Replication Problems
Date:   2005-11-14 08:41:13
From:   scandog
I have gone through your tutorial but have ended up with problems. When I do a mysql dump I don't get any lines for bin file or start position. Also when I upload the sql statement to the slave it remove all the slave user info I added. I would think you wouldn't want to export the mysql database. What is the point of adding a mysql replicant user that points to the master if your going to over write it with the master dump file. Also my servers have different names, and after dumping the file and adding it to the slave I can't access the database from my database software because the host names have changed.

I would also assume that you would have to restart the mysql servers after altering the my.cnf info, am I correct?

Thanks for any help you can give.

1 to 2 of 2
  1. Replication Problems
    2005-12-22 07:51:58  aquariusrick [View]

  2. Russell Dyer photo Replication Problems
    2005-11-26 04:31:34  Russell Dyer | O'Reilly Author [View]

1 to 2 of 2