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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
