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

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

Re: load data infile question

Hi, Harpreet: You should use MySQL C API mysql_escape_string(...) to convert that description field into a legal SQL string before load data infile. B.R. budingc - Original Message - From: Harpreet Kaur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 4:41

how to do when the table files become bigger and bigger

Hi, all: I am doing a project that we will insert a lot of data to mysql by C API everyday, so the table files will become bigger and bigger, it will not only takea long time to query,but also lead to the file size limits. In order to query fast and avoid leading to the file size limits,

how to do when the table files become bigger and bigger

Hi, all: I am doing a project that we will insert a lot of data to mysql every day, so the table files will become bigger and bigger, it will not only take a long time to query,but also lead to the file size limits. So how to resolve it? Are there some artiles related? Thanks for any

Why can't use INDEX while querying?

Hi, all: I create a table as following: CREATE TABLE appsvr_trarte ( rte_id bigint(38) NOT NULL auto_increment, strConfName varchar(70) NOT NULL default '', lFromTime int(16) unsigned NOT NULL default '0', lToTime int(16) unsigned NOT NULL default '0', iSvrType tinyint(2)

another problem and Re: Why can't use INDEX while querying?

Hi,all: Thanks to Egor Egorov, you are right. Also thanks to Rob Emerick. Unfortunately, I encountered another problem as following: mysql explain SELECT max(iSpeed),avg(iSpeed) FROM appsvr_trarte where lFromTime = 1009818000 and lFromTime 1012496400 and iSvrType = 33;