Error using MySQL Workbench – unhandled exception list index out of range.
While Loading the data using MySQL Workbench, you may hit the error unhandled exception list index out of range
There are no clues in the workbench log files, in such cases you can load the Data Using MySQL LOAD DATA Statement . Which will load the data very fast and without errors.
mysql> LOAD DATA LOCAL INFILE "C:/\Patient.csv" -> INTO TABLE xxhc_patient -> FIELDS TERMINATED BY ',' -> ENCLOSED BY '"' -> LINES TERMINATED BY '\n' -> IGNORE 1 ROWS; Query OK, 58 rows affected, 232 warnings (0.04 sec) Records: 58 Deleted: 0 Skipped: 0 Warnings: 232
In case if you get the following errors , run the below commands and re-execute load data statements.
ERROR: Loading local data is disabled - this must be enabled on both the client and server sides
ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.
mysql> SET GLOBAL local_infile=1;
mysql --local_infile=1 -u<username> -p<Password> DB_NAME
Hi there, This is SCP Ranga Rao Sanka working as (A product Manager/Principal DBA)., I have a broad range of Experience in Administration and Implementation in the areas of Database, Cloud, and Other Servers. I am one of the moderators at ORAFAQ. The primary purpose of this blog is to share knowledge.
All the code snippets, URLs, and everything in this blog are from My experience, My Learnings from different websites & forums. so please test the posts on your testing Environment first.
The experiences, Test cases, views, and opinions, etc., expressed on this website are my own and do not reflect the views or opinions of my employer.
This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content. Product and company names mentioned on this website may be the trademarks of their respective owners. I am not responsible for any kind of Damage or any legal activities.
Sriram Sanka 
Leave a comment