*SOLVED* mysqlimport: file stat error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

*SOLVED* mysqlimport: file stat error

Post 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.
Last edited by pickle on Tue Mar 09, 2004 3:55 pm, edited 1 time in total.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post 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!!
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply