Wolfgang - > I have a text file with 120'000 lines. When I do a > load data local infile > only 85'416 records are loaded. There is no message of the sort > Query OK, X rows affected > just the next prompt is displayed. > > I'll be glad for any hint what could cause this behavior. I'm using > version 4.0.15-nt on Windows 2000.
If you're loading the text file data into an existing table in your database check to see if an index is preventing records which would violate it from loading. You also may need to specify field (column) and line delimiters in the LOAD DATA command if, for examples, values in the records you are trying to load contain tabs, new line and other "special" (to MySQL) characters. Different options, and good examples, are documented for MySQL 4.x here: http://www.mysql.com/doc/en/LOAD_DATA.html - Jim ----- James Cradock, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
