Tom Cunningham <[EMAIL PROTECTED]> wrote:
>
> In short: what is the standard MySQL handling of temporary tables,
> *especially* when you've got a slave filter on to only replicate certain
> tables?
These options apply to the temporary tables too.
>
> My replication stopped over the weekend, because a query was executed
> which created temporary tables, then used that table to update one of
> the non-temporary tables which I was replicating.
>
> Do I need to add all possible temporary tables to my slave-side
> replication filter? (i.e., replicate-do-table=temp1, temp2, ...) (even
> when I did so, it didn't seem to work, but I'll have another go).
>
For replicate-do-table option you should also specify database name. Look at
replicate-wild-do-table option where you can use wildcard characters in the database
and table names. For example:
replicate-wild-do-table=db%.temp%
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
