Why would MySQL Workbench Table Data Import Wizard import 0 records?
<p>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.</p>

<p>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.</p>

<p>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:</p>

<p>"0 records imported"</p>

<p>and the table remains blank as before.</p>

<p>Frustratingly if I import into a <em>new</em> 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.</p>

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

<p>My apologies in advance if I did not include enough information.</p>

<p>Thank you.</p>