MySQL Workbench import restriction

Question

I am trying to import data from a csv file into MySQL Workbench 6.3.5 using the table data import wizard. I have about 400,000 rows of data, but the wizard only imports 27,016 rows of data.

Is this a mistake or restriction on importing data through MySQL Workbench?

Answer 1

I had a similar problem with my data import.

I opened CSV in Notepad ++ and found that Excel saved it with ANSI encoding, not UTF-8. When I changed the encoding to UTF-8, he suggested that the line in which my request was imported contained invalid characters.

, . , .

Answer 2

, " ", MySQL Workbench. , .

LOAD DATA local INFILE 'file path' 
INTO TABLE tablename FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'LINES TERMINATED BY '\n' IGNORE 1 ROWS LIMIT 0, N;

N - csv