I’m using LOAD DATA LOCAL INFILE and for some reason it only imports half the data.
I tried doing 68254 rows of data and it did 34127.
I then tried doing 68256 of data and it did 34128.
If I use the replace option and run the query 2 times the second time will import all the data. Any idea? I’m guessing its a setting somewhere, but thought I would post this while I go and look around.