Hi, I'm having a similar problem using the LOAD DATA. I get an intermittent error: ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
The command is: LOAD DATA local infile 'pipefile' into table FACT_TABLE fields terminated by '~' lines terminated by '\n'; I cannot seem to replicate it all the time. I have a PERL program that writes to the PIPE and MySQL reads the pipe. Did you have any success in figuring out the problem? Regards, George sol beach <[EMAIL PROTECTED]> wrote: >I've tried looking up this error code on www.mysql.org & via Google. > >I'm not sure it matters but if you look closely at the SQL below, >you can see it is working on file "page_path.tab4". > >It has already successfully loaded files page_path.tab1 thru page_path.tab3 > >I seriously could use a CLUE on what needs to be changed to avoid this error. > >TIA! > >Welcome to the MySQL monitor. Commands end with ; or \g. >Your MySQL connection id is 183 to server version: 3.23.58-max > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > >mysql> LOAD DATA CONCURRENT LOCAL INFILE >'../data/mysql/initial_20050318_102517/page_path.tab4' > -> REPLACE INTO TABLE page_path > -> FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '"' LINES >TERMINATED BY '\n' > -> (PAGE_PATH_ID,NAME,DATE_CREATED); >ERROR 2013: Lost connection to MySQL server during query >mysql> > >[EMAIL PROTECTED]:/b/martgen/mysql/bin>grep -i large show-variables.log >large_files_support ON >[EMAIL PROTECTED]:/b/martgen/mysql/bin>uname -a >Linux sdb2.hitbox.com 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT >2003 i686 i686 i386 GNU/Linux >[EMAIL PROTECTED]:/b/martgen/mysql/bin> > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________________________________________ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
