Re: LOAD DATA INFILE - "Duplicate entry '' for key..."

2002-01-25 Thread DL Neil
riginal Message - From: "Bogdan Stancescu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 25 January 2002 00:22 Subject: Re: LOAD DATA INFILE - "Duplicate entry '' for key..." > Just for the record, found the glitch: somehow, somebody on the way

Re: LOAD DATA INFILE - "Duplicate entry '' for key..."

2002-01-24 Thread Bogdan Stancescu
Just for the record, found the glitch: somehow, somebody on the way decided to change LF's into CRLF's (I remotely dumped the data and e-mailed it locally where I test the setup process, so maybe the mail agent?). I just had to replace 0x0d0a's into 0x0a's in a hex editor and everything works

LOAD DATA INFILE - "Duplicate entry '' for key..."

2002-01-24 Thread Bogdan Stancescu
Hi all! I bumped in a strange problem. I dumped a help table (i.e. only text) into a file. The table contains two fields: a "topic" (unique) field and a "content" field. Then performed a "LOAD DATA INFILE" on the resulting file in a different database with identical structure. Everything work