Bug #83471 importing external document
Submitted: 20 Oct 2016 19:07 Modified: 21 Oct 2016 16:48
Reporter: Salathiel Vann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3 OS:Windows
Assigned to: CPU Architecture:Any
Tags: Importing CSV

[20 Oct 2016 19:07] Salathiel Vann
Description:
I am having trouble importing a CSV file into my database table.  I am receiving error message "Operation failed: There was an error while applying the SQL script to the database."  Any suggestions

How to repeat:
1. Select Import
2. Choose the CSV file
3. Click Apply
4. Click Apply again
5. Then the error message appears and the only option is to select "back or cancel"
[21 Oct 2016 9:17] MySQL Verification Team
Are you using 6.3.7 otherwise try it. Thanks.
[21 Oct 2016 14:23] Salathiel Vann
I used the feature to "check for updates" and I received a pop up stating "you are already using the latest version of MySQL Workbench".
[21 Oct 2016 14:32] MySQL Verification Team
Please check the version using from menu Help->About WorkBench and if needed download from http://dev.mysql.com/downloads/workbench/. Thanks.
[21 Oct 2016 15:01] Salathiel Vann
Thanks.  The update pushed me to version 6.3.8.  I was able to import without receiving the error message as before.

However, during the import process, I imported 53 records, only 36 got imported according to the MySQL Import Wizard.  Any ideas as to why all records may not import into my table?
[21 Oct 2016 16:05] Salathiel Vann
Never mind.  I figured it out.  It initially imported 17 out of 53 and gave me the error message that I reported in this ticket.  After the update, it imported the rest of the 53 records; which was the 36.  So, it appears to be working like it should
Thanks!
[21 Oct 2016 16:48] MySQL Verification Team
Thank you for the feedback.