CODEWITHSUNDEEP
mysql
Bhuvan raj
Bhuvan raj

Reputation: 413

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.

Upvotes: 4

Views: 26166

Answers (3)

Seb
Seb

Reputation: 111

For Ubuntu users,

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

Another useful link talking about apparmor configuration.

Upvotes: 7

k to the z
k to the z

Reputation: 3185

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.

Upvotes: 12

Quassnoi
Quassnoi

Reputation: 425823

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

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

Upvotes: 2

Related Questions