Friday, April 25, 2014

ERROR 29 (HY000): File 'D:\ est.csv' not found (Errcode: 2 - No such file or directory)

ERROR 29 (HY000): File 'D:\     est.csv' not found (Errcode: 2 - No such file or directory)
I got this error while executing below command in mysql

LOAD DATA INFILE 'D:\test.csv'
INTO TABLE emp
COLUMNS TERMINATED BY ';'
LINES TERMINATED BY '\r\n';

Problem : Path is not correctly define after INFILE
Solution : Use forward slash instead backward slash.
    LOAD DATA INFILE 'D:/test.csv'
   INTO TABLE emp
   COLUMNS TERMINATED BY ';'
   LINES TERMINATED BY '\r\n';

2 comments:

web stats