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