Greetings,
I am attempting to use MySQL's MERGE feature to link tables from different
databases. All tables have identical structures, and I need to do this
because each table is right up against the 2-Gbyte limit imposed by Linux's
ext2 filesystem.
System info: OS is RH Linux 7.1 (2.4.3-12smp kernel), MySQL version is
3.23.36-1.
When I create two small tables within the SAME database and then run a
merge, everything works fine. However, when I run similar commands across
multiple databases, even with small tables, I get an error. In the following
example, t1 and t2 have 10,000 records apiece.
#
# First make and populate t1
#
CREATE DATABASE t1;
USE t1;
CREATE TABLE t1 (type VARCHAR(16), price DOUBLE INDEX (type));
LOAD DATA INFILE 't1.csv' INTO TABLE t1
FIELDS TERMINATED BY ',';
#
# Now create and populate t2
#
CREATE DATABASE t2;
USE t2;
CREATE TABLE t2 (type VARCHAR(16), price DOUBLE INDEX(type));
LOAD DATA INFILE 't2.csv' INTO TABLE t2
FIELDS TERMINATED BY ',';
#
# Now make a union between t1 and t2 called total
#
CREATE DATABASE total;
USE total;
CREATE TABLE total (type VARCHAR(16), price DOUBLE INDEX(type))
TYPE=MERGE UNION=(t1.t1, t2.t2);
DESCRIBE total;
This last command produces the following error:
ERROR 1017: Can't find file: 'total.MRG' (errno: 2)
When I examine total.MRG I see that its contents are simply "t1" and "t2" on
individual lines. Editing the file to "t1.t1" and "t2.t2" has no effect, nor
does changing permissions on total.MRG to 777.
How can I get the union to work?
Also, a question about merges: In the example above, if t1 and t2 are huge,
will the resulting 'total' also be huge?
Thanks in advance.
Regards,
David Newman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
