From: Rilawich Ango (maillistinggmail.com)
Date: Wed Mar 28 2007 - 05:19:51 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,
  As I know, master will replicate all database to the slave in
default. If I want to replicate only specified database, we can use
parameter in master.
binlog-do-db=databasename

  I found that we can also use parameters to replicate database even
table in slave.
replicate-do-db=db_name (replicate this database)
replicate-ignore-db=db_name (don't replicate this database)
replicate-do-table=db_name.table_name (replicate this table)
replicate-ignore-table=db_name.table_name (don't replicate this table)

  I have tried the second method but nothing to replicate. Anyone can
tell if it works for you.
ango

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]