Hi, We are using the binary distribution of mysql for solaris 9 64bit on 2 machines that are replicating to each other for redundancy:
mysql-standard-4.0.14-sun-solaris2.9-sparc-64bit I am successfully able use replicate-ignore-db=blah to stop replication on a database, however when I specify individual tables to ignore the slave thread continues to replicate the tables completely oblivious to the ignore statement. I have so far tried to get the slave to ignore nearly every table in the target database to no effect. Only replicate-do-db & replicate-ignore-db work Here is a sample of my.cnf [mysqld] port = 3306 socket = /tmp/mysql.sock log = /var/log/mysql/mysqld.log log-error = /var/log/mysql/mysqld-error.log log-slow-queries = /var/log/mysql/mysqld-slow.log datadir = /var/lib/mysql skip-locking key_buffer = 256M max_allowed_packet = 100M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M net_buffer_length = 8K myisam_sort_buffer_size = 64M thread_cache = 8 thread_concurrency = 4 query_cache_size = 16M log-bin server-id = 2 master-host = somehost.somedomain master-user = replicator log-bin log-warnings log-slave-updates replicate-ignore-db=mysql replicate-ignore-table=radius.Accouting replicate-ignore-table=radius.RADAUTHLOG replicate-ignore-table=radius.RADSTATSLOGns1 replicate-ignore-table=radius.RADSTATSLOGns2 replicate-do-table=radius.raduser replicate-do-table=radius.RADONLINE replicate-do-table=radius.RADPOOL Cheers Lee Webb -- Systems Administrator DOT Communications [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
