Экспорт csv файла в MySQL
"33996344","33996351","GB","GBR","UNITED KINGDOM"
"50331648","69956103","US","USA","UNITED STATES"
"69956104","69956111","BM","BMU","BERMUDA"
"69956112","83886079","US","USA","UNITED STATES"
"94585424","94585439","SE","SWE","SWEDEN"
их там более 56000
Пишу запрос
load data infile '/path/to/file.csv' into table iptocountry fields terminated by ',' enclosed by '"' lines terminated by '\n';
А БД заносить тока 28000 записей а остальные 28 раскидываються в последнее поле
33996344 33996351 GB GBR UNITED KINGDOM""50331648
69956104 69956111 BM BMU BERMUDA""69956112
Из-за чего такое можт быть?