Page 1 of 1

Replicating several databases

Posted: Thu Oct 12, 2006 5:45 am
by determinedmoth
Hi
I have replication set up between my primary server and it's failover. Currently I have 1 database set up that caters for all sites on that box. Being that that is a security issue, each new site is going to get it's own database.

So, I have database_1, and I have added database_2. How do I go about adding database_2 to the current replication setup? I've not found any information thus far to help me with this and swear I must be missing something obvious.

Thanks.

Posted: Thu Oct 12, 2006 6:18 am
by determinedmoth
ah ah. Got it.

--replicate-do-db=db_name

The way is to simply add another line in my.cnf as above...

As you were!