Re: replication of temporary tables

2004-05-13 Thread Egor Egorov
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, b

replication of temporary tables

2004-05-12 Thread Tom Cunningham
Hi, 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? My replication stopped over the weekend, because a query was executed which created temporary tables, then used that table to update one of t

Re: Replication of temporary tables

2002-03-04 Thread Rafael Martinez
On 26 Feb 2002, Arjen Lentz wrote: > On Tue, 2002-02-26 at 12:21, Peter Jennings wrote: > > We have been trying to solve a replication issue related to TEMPORARY > > tables. > > > > Here's the issue > > > > Every three hours we run a processX (C++ compiled program) on the Master > > mysql that

Re: Replication of temporary tables

2002-02-25 Thread Arjen Lentz
Hi Peter, On Tue, 2002-02-26 at 12:21, Peter Jennings wrote: > We have been trying to solve a replication issue related to TEMPORARY > tables. > > Here's the issue > > Every three hours we run a processX (C++ compiled program) on the Master > mysql that goes something like this: > > CREATE TEM

Replication of temporary tables

2002-02-25 Thread Peter Jennings
We have been trying to solve a replication issue related to TEMPORARY tables. Here's the issue Every three hours we run a processX (C++ compiled program) on the Master mysql that goes something like this: CREATE TEMPORARY TABLE tempTableA INSERT INTO tempTableA INSERT INTO normalTableB SELECT