Quoting Norman Khine <nor...@khine.net>:


What is shown from "show master status" and "show slave status" after you
have made a change on the master DB?
this is the output:

http://pastie.org/1100610

it does not seem to have any changes and "show slave status" is just empty.

have i missed to add something to the master's /etc/mysql/my.cnf options?

So you can see the binlog position on the master has not changed, hence you wont get any changes replicated to the slave. The show slave status has to be run on the slave not the master. Anyway, I believe your problem is your binlog-do-db section on the master, and also the ignore sections, I think these need to be broken into seperate lines, with only one value per line. ie:

binlog-do-db = upgrade
binlog-do-db = tracker

You´ll need to completely resetup the syncronsiation after this, as you currently have out of sync DBs and no data stored in your binlogs...





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

Reply via email to