Yes, MERGE Tables is useful for getting around the file size limit problem.
However, Linux 7.2(Kernel 2.4.x), MySql 3.23.47 supports file sizes greater
than 4GB. Mysql 3.23 by defaul will create tables that can grow only upto 4G
but these can be altered using ALTER TABLE. You willl need to alter
AVG_ROW_LENGTH and MAX_ROWS, the product of which is the file size that will
be supported.
http://www.mysql.com/doc/T/a/Table_size.html
Also, if you do not want to go that route, you can use MERGE tables which
will merge 2 or more underlying tables, say,
AAA1 AAA2 into AAA. so you can either refer to AAA or indivually to AAA1
and AAA2.
Generally, you want to refer to AAA while quering and the indiviudal tables
while inserting/updating data.
Regards,
Bhavin.
- Original Message -
From: Buding Chen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 7:23 PM
Subject: file size limit hitting when LOAD DATA INFILE
Hi, all:
I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When LOAD
DATA INFILE to a table whose file size is 4G, it fails and
mysql_error(...)
reports Lost connection to MySQL server during query. How can I clearly
know the failed reason is just hit the 4G file size limit?
If the 4G file size limit is hit, I have two ways to resolve it: (1)
create a new table and LOAD DATA INFILE into this new table. (2) backup
this table and clear it and reload. However, these two ways are troubled
and
not good. Dose some one have a effective way that just LOAD DATA INFILE
without hitting file size limit? Dose MERGE Table help it here?
Thanks in advance.
B.R.
Buding
-
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
-
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
