Chris Ward, can you please help? I have a mysql db with a table for requests. I have the requests.id field as primary key.
Upon doing LOAD DATA LOCAL INFILE to load each file manually until I get the process figured out, I'm noticing that some of the data files are throwing messages that records were skipped.
Is it possible that some of these records have been duplicated in some of the daily data dumps? Or that the request ID field is re-used?
This is the worst one so far. I've loaded 15 files and so far 3 have had skipped records.