I want to stop replication for one table in the database. According to the mysql documentation: I need to add the parameter (replicate-wild-ignore-table ) to the my.cnf file. I have some question.
#1 In what database I should made the change to my.cnf? Slave or Master?
#2 Than I should restart the database. I use Linux. So I just need to restart mysqld?
http://www.mysql.com/doc/en/Replication_Options.html says:
--replicate-wild-do-table=db_name.table_name
Tells the slave thread to restrict replication to queries where any of the updated tables match the specified wildcard pattern.
So you would use this option on the slave host. Restart the slave server after adding the option to its my.cnf file.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
