MySQL Replication: replicating specific databases/tables only

// replicate this database
replicate-do-db=database_name

// don’t replicate this database
replicate-ignore-db=database_name

// replicate this database.table
replicate-do-table=database_name.table_name

// don’t replicate this table
replicate-ignore-table=database_name.table_name

// allows wildcards, use % as the wildcard character
// e.g db% would be all databases beginning with db
replicate–wild-do-table=database_name.table_name

// ignore all specified tables, with wildcards
replicate-wild-ignore-table=db_name.table_name

Twitter Digg Delicious Stumbleupon Technorati Facebook

Comments are closed.

Random Pages By Best Accounting Services