I use Linux (CentOS) to run my web server, and I use MySQL for the database.
I need to do the following from a mysql command line:
LOAD DATA INFILE '/home/mydir/dump.txt' INTO TABLE my_db.table FIELDS TERMINATED BY '||';
But I get the following error:
ERROR 13 (HY000): Can't get stat of '/home/mydir/dump.txt' (Errcode: 13)
I think the problem is that MySQL does not have permission to access '/home/mydir/dump.txt'.
I changed both the owner and the group for '/home/mydir/dump.txt' to 'nobody' and I change its permission to 777 but I still get the error!