Re: loading data problem

[Rick James]

Most LOAD DATA problems can/should be addressed _after_ loading.

A common pattern is to LOAD into an extra table, then perform transforms while moving the data into the real table. (Then DROP or TRUNCATE-and-reuse the extra table.)

In your case, have an AUTO_INCREMENT in the extra table, do no include that column in the LOAD statement. Then, when moving to the real table, do
INSERT INTO real_table (...)
SELECT ... FROM extra_table WHERE id != 7952;

The two "..." could
* avoid the id column (in your case) or other unwanted columns,
* allow for rearranging the columns,
* have expressions,
* convert datatypes,
* etc.