LOAD DATA INFILE not working in mariadb
- by Haseena
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? Login as Administrator.
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 loke "C:/SampleFile0", its working properly. From Administrator folder it doesn't working.
Can anyone help me in this regard??? Iam a newone in MariaDB.