MySQL Workbench import limit

Question

I am trying to import data from a csv file to MySQL Workbench 6.3.5 using the table data import wizard. I have about 400000 rows of data but the wizard is importing only 27016 rows of data.

Is it a bug or limit on importing the data through MySQL Workbench?

Can you do it from the command line and see if you get the same result? — Clay
– Clay, Commented Dec 13, 2015 at 7:51
I would check the input file around line 27016. Perhaps it is malformatted. — Shadow
– Shadow, Commented Dec 13, 2015 at 7:59
@RichardSt-Cyr Nope, i didn't get any error or status message. — scarecrow
– scarecrow, Commented Dec 17, 2015 at 9:45
@Shadow csv file i am using is generated using mysql-workbench only — scarecrow
– scarecrow, Commented Dec 17, 2015 at 9:45

Burgi · Accepted Answer · 2018-01-02 17:21:07Z

2

I had a similar issue with my data import.

I opened the CSV in Notepad++ and found that Excel had saved it with an ANSI encoding rather than UTF-8. When I swapped the encoding to UTF-8 it highlighted the fact that there were invalid characters on the row my import was failing on.

I manually removed these characters and the import worked perfectly. It might be worth sanitizing your input data in a similar way.

answered Jan 2, 2018 at 17:21

Burgi

4398 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Achlys · Accepted Answer · 2017-07-11 07:55:01Z

-1

Make sure that while importing you are using "Don't limit" option in MySQL Workbench. If you are not able to find that option then you can use the following query.

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

where N-the number of rows in the csv file

edited Jul 11, 2017 at 7:55

answered Jul 11, 2017 at 7:35

Achlys

13 bronze badges

Collectives™ on Stack Overflow

MySQL Workbench import limit

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related