Link to home
Start Free TrialLog in
Avatar of hankknight
hankknightFlag for Canada

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!
ASKER CERTIFIED SOLUTION
Avatar of Warpseh
Warpseh
Flag of Argentina image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Arty K
Arty K
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial