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.

score 12 · Accepted Answer · answered Apr 01 '11 at 15:31

12

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.

answered Apr 01 '11 at 15:31

k to the z

score 7 · Answer 2 · edited May 23 '17 at 12:18

7

For Ubuntu users,

Another useful link talking about apparmor configuration.

edited May 23 '17 at 12:18

Community

answered Jan 04 '13 at 14:51

Seb

score 2 · Answer 3 · answered Apr 01 '11 at 15:29

2

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

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

answered Apr 01 '11 at 15:29

Quassnoi

3 Answers3