Fix for the the "Table Data Import Wizard".
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...
Subject
Views
Written By
Posted
Fix for the the "Table Data Import Wizard".
2448
August 19, 2022 07:55AM
455
August 19, 2022 11:40AM
Sorry, you can't reply to this topic. It has been closed.
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.