Getting error to bulk export to mysql

[ankit_kalal]

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 ??

[andrew.rybka]

Hello @ankit_kalal and welcome to the Community!

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

[ankit_kalal]

I sincerely appreciate the support.
Thank You.