How to fix ERROR 29 (HY000) in mysql?

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.

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.

For Ubuntu users,

Check you currently use: mysql -u user -p --local-infile.

Another useful link talking about apparmor configuration.

If the file is located on your client machine, you should use this:

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