Page 1 of 1

*SOLVED* mysqlimport: file stat error

Posted: Tue Mar 09, 2004 3:40 pm
by pickle
Hi All,

I'm trying to import data into a MySQL table, and I keep getting the error

mysqlimport: Error: Can't get stat of '/home/usr/DUMP/data_file.txt' (Errcode: 13), when using table: importing_table

(obviously file and table names have been changed).

I have changed the owner of both the DUMP folder and all files in the folder to mysql.mysql. I have also chmod'ed the folder and files to 777. I'm logged in as root, and I'm running mysqlimport as root as well. Any help will be greatly appreciated. Thanks.

Posted: Tue Mar 09, 2004 3:55 pm
by pickle
Ha, nothing helps you find the answer yourself more than asking others for help. After some research, I found that for some reason, attaching the "-L" argument make it work. "-L" makes it read using the local client. While I'm not entirely sure what it means, it worked for me and it's worked for others. Booyah!!