Re: Temporal tables and slave replication

[alv4ro Vtt]

Aftab Khan Wrote:
-------------------------------------------------------
> >Thanks, but I want to do a
> replicate-wild-to-table of every table of
> powersystem DB except temporal tables because is
> an slave.
>
> By default all tables are replicated. Please note
> --replicate-wild-do-table is checked first, so if
> the match found, mysql would execute command
> against the table, thus
> --replicate-ignore-wild-table won't be checked.
>
> So your temporary tables use 'temp' prefix?
>
> Use following in your mysql options file
> (/etc/my.cnf)
>
>
>
>
> ...
> replicate-wild-ignore-table = powersystem.temp%
>
>
Now I'm trying with that.
>
> What other replication specific options do you
> use? Can we see your mysql options file?

I had only these two options. I have removed and keeping only wild-ignore.

Thanks!