Hello, On Sun Saloris box, can anyone tell me how to load data into non-empty tables? Can you give me an example? Any help appreciates!
Cindy >>> Bogdan Stancescu <[EMAIL PROTECTED]> 01/24 4:22 PM >>> 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
