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?
sol beach <sol.beach@stripped> 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.
>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
> -> 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@sdb2:/b/martgen/mysql/bin>grep -i large show-variables.log
>Linux sdb2.hitbox.com 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
>2003 i686 i686 i386 GNU/Linux
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
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