i just loading the text file into table ...... then i got error like this

Question

Error

SQL query:

LOAD DATA LOCAL INFILE '/home/sharma/Desktop/New.txt' INTO TABLE FIELDS FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'

MySQL said: Documentation

2 - File '/home/sharma/Desktop/New.txt' not found (Errcode: 2)

Answer 1

Check that the file exists and that you & the mysql server user have access to read it.

Answer 2

If your file is located on server host, try to load it without the LOCALE keyword.