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.
*SOLVED* mysqlimport: file stat error
Moderator: General Moderators
*SOLVED* mysqlimport: file stat error
Last edited by pickle on Tue Mar 09, 2004 3:55 pm, edited 1 time in total.
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.