MySQL Replication With Specific Database

02 Jan 2014

#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.
comments powered by Disqus