Re: MERGE table problem

2006-08-24 Thread Chris
Eric Anderson wrote: I've got a master (Master) with a MERGE table of foo_t (comprising of bar_a, bar_b, bar_c) in database 'Igloo'. There are 5 slaves that replicate the Igloo table, but ignore the Igloo.foo_t table. This setup was working fine. If the Master server crashed or had a prb

MERGE table problem

2006-08-24 Thread Eric Anderson
I've got a master (Master) with a MERGE table of foo_t (comprising of bar_a, bar_b, bar_c) in database 'Igloo'. There are 5 slaves that replicate the Igloo table, but ignore the Igloo.foo_t table. This setup was working fine. If the Master server crashed or had a prblem for some reason, I

"MERGE Table Problem"

2004-06-11 Thread Michael Arndt
Hello * reproducable Problem: Content of UNION: logs_20040608,logs_20040609,logs_20040611,logs_20040612,logs_20040613,logs_20040614, logs_20040615 results: 0E0 DBD::mysql::db do failed: Can't open file: '#sql-13c1_12.MRG'. (errno: 144) at /usr/local/sbin/new_MERGE_table.pl line 276. Unable to

Merge table problem.

2001-03-02 Thread Michael Widenius
Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello monty, Peter> I'm trying to use merge table for logging - to have a possibility to Peter> Rotate log files and to quickly delete old data - for this I'm goint Peter> to setup a number of merge tables where each co

Merge table problem.

2001-02-17 Thread Michael Widenius
Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello monty, Peter> I'm trying to use merge table for logging - to have a possibility to Peter> Rotate log files and to quickly delete old data - for this I'm goint Peter> to setup a number of merge tables where each co

Re: Merge table problem.

2001-02-17 Thread Fred van Engen
On Fri, Feb 16, 2001 at 05:58:27PM +0300, Peter Zaitsev wrote: > Hello monty, > > I'm trying to use merge table for logging - to have a possibility to > Rotate log files and to quickly delete old data - for this I'm goint > to setup a number of merge tables where each contains data for one

Merge table problem.

2001-02-16 Thread Peter Zaitsev
Hello monty, I'm trying to use merge table for logging - to have a possibility to Rotate log files and to quickly delete old data - for this I'm goint to setup a number of merge tables where each contains data for one day, and the inserts are done to the last table using real table name