About EasyMorph Tutorials & Examples Web-help

Getting error to bulk export to mysql

I’m trying to export bulk data to MySQL with this SQL query

LOAD DATA
LOCAL INFILE ‘C:/Users/Administrator/Desktop/test.csv’
INTO TABLE tw_test_easymorph.stage_tcad_special_propdata
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’
IGNORE 1 lines;

this query works fine when I run this on MySQL workbench
but when I try to execute this query with easymorph(Database command).
I’m getting this error.
Error: The used command is not allowed with this MariaDB version
Source: action “Database command”, table "Special_Improvement.txt"

Why I’m getting this error and how can I solve this ??

Hello @ankit_kalal and welcome to the Community!

Try to add a custom connection property AllowLoadLocalInfile and set it to true. Like this:

image

1 Like

I sincerely appreciate the support.
Thank You. :slight_smile:

To learn more about EasyMorph visit easymorph.com.