How to fix ERROR 29 (HY000) in mysql?

Question

When I use this command below in Mysql client 5.1 in ubuntu:

load data infile 'words.csv' into table words;

I'm getting this error:

ERROR 29 (HY000): File '/var/lib/mysql/bhuvan/words.csv' not found (Errcode: 2)

Help me out.

Answer 1

Try

load data local infile 'words.csv' into table words 
fields terminated by ','
enclosed by '"'
lines terminated by '\n';

If your words file is in your / directory.