Another question (if you don’t mind?) … now that I’ve figgured out the replication thing, what extra would be necessary to replicate more than one database stored on the same server? For example, I have DatabaseOne and DatabaseTwo. DatabaseOne stores tables for ApplicationOne (a client tracking App) and DatabaseTwo stores tables for ApplicationTwo (an Inventory App) neither of which are associated to each other.
Would I simply have two statements in the config file such as…
On the server:
binlog-do-db=DatabaseOne, DatabaseTwo
On the client:
replicate-do-db=DatabaseOne, DatabaseTwo
or???
And how would I then issue the CHANGE MASTER statement to reflect more than one log file (assuming there would be one that is)? … or would just the one log file hold all the replication info for the 2 databases?
-OR- maybe I should just get the book and do a lotta reading and stop asking so many questions? LOL