CODEWITHSUNDEEP
mysqlcsvimportmysql-workbench
Fraoch
Fraoch

Reputation: 21

Why would MySQL Workbench Table Data Import Wizard import 0 records?

I'm very inexperienced with MySQL and I'm having a lot of problems. I'm using MySQL Workbench 6.3 on Linux Mint 17.3.

I'm trying to import a CSV file into a table using the Table Data Import Wizard. This works fine for a simple table but is failing for a more complex table.

I'm correcting everything in the import wizard to make sure each row and column is perfect. It seems to work at first, importing my ~14000 rows takes time, there's disk activity and no errors are reported, but at the end:

"0 records imported"

and the table remains blank as before.

Frustratingly if I import into a new table everything works as expected. I notice that the data types are quite different though. I've tried to force the data types in the .CSV file to correspond to what is expected. I also made sure that "NULLABLE=NO" fields did have something in them. But if I broke any of these rules, wouldn't there be errors? I even tried importing just one line, thinking that maybe somewhere in this largish table there's some bad data, but I can't even import one line.

Why would there be no errors, yet "0 records imported" into an existing table, but everything works fine with a new table?

My apologies in advance if I did not include enough information.

Thank you.

Upvotes: 2

Views: 8042

Answers (1)

Fahad Khan
Fahad Khan

Reputation: 67

The solution is to import ~2000 records in each import. I believe there is a memory issue with the DB. I came across the same situation and I was uploading ~9000 records. Everything including datatypes were perfect.

Upvotes: 1

Related Questions