load data infile - deleted, warnings, skipped - MySQL

[roch77@gmail.com]

Hi,
I just loaded 71,000 records using "load data infile" and when done it
gave no warnings, but said it skipped 4. Is there any record anywhere
of which 4 records didn't get loaded or any other info about it?
I know about the show warnings, but didn't find any "show skipped"
command?
I have also searched all the server log files. I am using mysqld
4.1.11 and Innodb.

I am assuming that either the data had some bad syntax, or that
referential integrity wasn't met. I didn't "set foreign_key_checks=0"
..

If the 4 records got skipped because of referential integrity checks,
will it say so, or does it always only give the message about
"deleted:0 skipped:4 warnings:0"

thanks in advance..
Roshan

[Bill Karwin]

Removed by Administrator

[roch77@gmail.com]

Thanks a lot Bill for your reply. After reading your post, I decided
to try to make sure my primary key was unique for each row. Sure
enough I got 4 rows with duplicate entries, so that was my problem.
Back to the drawing board to figure out the primary key.

Roshan