Thanks john, After some further checking, the files that I was trying to load back into the db where sent to me from a MAC, and had some strange C/R's in it, causing the file be formatted improperly! After fixing that, all the files loaded into the db fine! :)
thx's >>On Tue, 4 Dec 2001 08:45:27 -0600, "john" <[EMAIL PROTECTED]> wrote: >>remove your line termination and it will not look for this non-existing data >>and run through the whole file. >>john >> >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >>Sent: Monday, December 03, 2001 10:11 PM >>To: [EMAIL PROTECTED] >>Subject: Load data infile >> >> >>Be struggling with this all day, try to figure out why when using the 'load >>data >>infile..' all it loads is the first line for the text file and that's it! >> >>Table structure: >>CREATE TABLE `retailtag` ( >> `prodid` smallint(4) NOT NULL default '0', >> `tagnumber` varchar(10) NOT NULL default '', >> `code` varchar(10) NOT NULL default '', >> UNIQUE KEY `tagnumber` (`tagnumber`,`code`), >> KEY `prodid` (`prodid`) >>) TYPE=MyISAM; >> >>QUERY: >>$mysql> load data local infile '/home/tracerta/tmp/retailtag.txt' into table >>retailtag fields terminated by '|' lines terminated by '\n'; >> >>the text file is contructed as such: >> >>ID|NUM|CODE >>ID|NUM|CODE >>ID|NUM|CODE >>....etc >> >>approx., 1600 records >>But it only grabs the file line, and stops. I've tried it with a CSV format, >>and >>TAB format, still the same thing, grabs the first line, and that's it?? >> >>is the file in the wrong format?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= --------------------------------------------------------------------- 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
