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
