Hi Victor, Thanks for your reply. Yes, I did mean to only replicate certain tables, so your answer fits to a tee. Thanks!
On Wed, 2004-05-26 at 01:12, Victor Pendleton wrote: > What do you mean by storing a subset? Are you only wanting to replication a > portion of the tables? If so, you can configure the master to ignore certain > databases or you can configure the slave to apply updates for certain > databases/tables or prohibit the master from replicating certain > databases/tables. > Master my.cnf > binlog-ignore-db=<database-name> > OR > In the slave my.cnf file you use the > replicate-ignore-table=<table-name> > replicate-ignor-db=<database-name> > or > replicate-wild-ignore-table=<pattern> > > to replicate a `subset`. > > > -----Original Message----- > From: Callan Tham > To: [EMAIL PROTECTED] > Sent: 5/25/04 11:54 AM > Subject: Storing a subset of data in a slave database > > Hi everyone, > > I am trying to set up database replication, and would like to know if I > can store just a subset of data in the slave DB. Anyone has any insight? > > Thanks in advance, > Callan -- Callan Tham +65 6243 6800 Security Engineer +65 9679 7650 SecureCiRT Pte Ltd PGP : 3A34 8CFB B956 789F 778F 4A08 BC75 FEA6 7C2D C942
signature.asc
Description: This is a digitally signed message part
