On Tue, 20 Jan 2004, Todd Burke wrote: > Is there any way to disable replication of all temp tables using > replicate-ignore-table or some other means? The names of the temp tables > are generated randomly by a script. Thanks
If you could have all temporary tables starting with "tmp" or something like that (since the script generates the names it should be easy just to tag something at the start or end that makes them stand out), then you can use: (from manual: http://www.mysql.com/doc/en/Replication_Options.html) --replicate-wild-ignore-table=db_name.table_name Tells the slave thread to not replicate a query where any table matches the given wildcard pattern. To specify more than one table to ignore, use the directive multiple times, once for each table. This will work for cross-database updates. Please read the notes that follow this option list. Example: --replicate-wild-ignore-table=foo%.bar% will not do updates to tables in databases that start with foo and whose table names start with bar. Note that if you do --replicate-wild-ignore-table=foo%.% then the rule will be propagated to CREATE DATABASE and DROP DATABASE, that is, these two statements will not be replicated if the database name matches the database pattern (foo% here) (this magic is triggered by % being the table pattern). Escaping wildcard characters _ and %: see notes in the description of replicate-wild-do-table just above. cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]