mysqlimport reports Error: 29, File '/tmp/newTable.txt' not found (Errcode: 13), when using table: newTable

Question

For a while not I have been trying to import a tab separated text file into my mysql database. I keep getting this error.

A few forums advised that I should change the mode of the file and folder to 777. Which I did, but still the same error.

Error: 29, File '/tmp/vehicleMake.txt' not found (Errcode: 13), when using table: vehicleMake

score 12 · Accepted Answer · answered Jun 04 '12 at 14:15

12

Sorry for trouble, I used --local option and it worked.. Magic!!!

answered Jun 04 '12 at 14:15

Siddharth

9,349
16
86
148

1

It doesn't work anymore with recent versions of MySQL – Matteo Dec 11 '13 at 10:25

score 1 · Answer 2 · answered May 13 '15 at 14:13

1

The LOCAL option is no longer supported in most versions of MYSQL. In Ubuntu 14.04 and MYSQL 5.5 I moved the file to the /tmp directory and changed ownership of the file to mysql using the following in the shell:

sudo chown mysql.mysql <filename>

answered May 13 '15 at 14:13

y-i_guy

673
6
8

mysqlimport reports Error: 29, File '/tmp/newTable.txt' not found (Errcode: 13), when using table: newTable

2 Answers2