Bogdan, You solved your own problem - that's good (and the timestamps below hint that you have other abilities)
Did you realise that you could specify a LINES TERMINATED BY '\r\n' clause and stick with LOAD DATA? Oh the joys of working with *nix and Windows... =dn ----- Original 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 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 fine now. > > Bogdan > > On Friday 25 January 2002 01:56 am, Bogdan Stancescu wrote: > > 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 worked just fine. > > > > Later on, after some editing on the table via PHP, everything looked ok in > > PHP and I dumped the table once again. Guess what? "LOAD DATA INFILE" now > > says "Duplicate entry '' for key 1". The table structures continue to be > > identical. The original data in the second database doesn't exist anymore > > (this is actually needed for a setup process, so the database and table are > > created from scratch with the same code). The dump file looks ok - similar > > in every way with the original - I even searched for TAB characters and > > there's no TAB at the beginning of any line! > > > > What gives? Did anyone else bump into this kind of problem? > > > > Thanks in advance! > > > > Bogdan > > > > --------------------------------------------------------------------- > > 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 > > --------------------------------------------------------------------- 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
