CODEWITHSUNDEEP
mysqlload-data-infilemariadb
Haseena
Haseena

Reputation: 494

LOAD DATA INFILE not working in mariadb

Iam trying to migrate from mysql to mariadb. On this time I can face an issue with mariadb.

When I can trying to load a data file into a table, it shows an error like :

SQL Error (29): File 'C:/Documents and Settings/Administrator/Local Settings/Temp/SAMPLE/DATA_TEMP1351761841668/SampleFile0' not found (Errcode: 2)

But the file already exists in the path....

Another one point is that the same command successfully works with MySQL. Is MariaDB has any permission issue?

See below my query :

load data infile "'C:/Documents and Settings/Administrator/Local Settings/Temp/SAMPLE/DATA_TEMP1351761841668/SampleFile0" into table SAMPLETABLE;

When changing the path like "C:/SampleFile0", its working properly. Path from Administrator folder it doesn't working.

Can anyone help me in this regard??? Iam a newone in MariaDB.

Upvotes: 0

Views: 8718

Answers (2)

druid62
druid62

Reputation: 129

There is an unwanted single quote in your command.

Upvotes: 1

Danny Hong
Danny Hong

Reputation: 1482

can you try to add "local" ?

load data local infile "'C:/Documents and Settings/Administrator/Local Settings/Temp/SAMPLE/DATA_TEMP1351761841668/SampleFile0" into table SAMPLETABLE;

Upvotes: 2

Related Questions