MySQL Forums
Forum List  »  MySQL Workbench

Fix for the the "Table Data Import Wizard".
Posted by: Stanislav Dergatch
Date: August 19, 2022 07:55AM

In MySQL Workbench, the "Table Data Import Wizard" does not work properly and people have been complaining about it all over the Internet for several years now.
I encountered this issue today myself, and using the clues from the Workbench error log (at ~/Library/Application Support/MySQL/Workbench/log/wb.log) was able to fix it.

So, the problem is in the file /Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_export_be.py

If you replace
"with open(self._filepath, 'r') as csvfile:" with
"with open(self._filepath, 'r', newline='', encoding='utf-8') as csvfile:"
at lines 421 and also line 501, the import starts working properly.

(But the proper fix should perhaps take into account "encoding" setting selected by user in wizard screen dialog.)

Though it is still way slower (perhaps ~100 times) than using the "load data local infile" sql command. (But to get that one work also was not an easy task...)

Just FYI...

Options: ReplyQuote


Subject
Views
Written By
Posted
Fix for the the "Table Data Import Wizard".
96
August 19, 2022 07:55AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.