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
