hankknight
asked on
Linux/MySQL Permission Problem: ERROR 13 (HY000): Can't get stat
Hello,
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!
Please help!
Thanks!
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!
Please help!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.