List:General Discussion« Previous MessageNext Message »
From:Mike Spreitzer Date:August 15 2008 6:40am
Subject:ERROR 13 (HY000): Can't get stat of '/var/lib/mysql/e5publishers.txt' (Errcode: 13)
View as plain text  
I am running MySQL Community edition 5.0.51a-0.rhel4 (on RedHat Enterprise 
Linux 4).  I am unable to load data from a text file; when I try I get the 
error message in the subject of this email.  In the typescript below you 
will see two tries, with all the necessary file and database permissions. 
In both cases the file and the whole path to the file is world-readable. I 
logged into MySQL using the root account, which has all MySQL privileges. 
What is going wrong here?

[root@xd026 ~]# su - mysql
-bash-3.00$ pwd
/var/lib/mysql
-bash-3.00$ mysql --user=root --password e5
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 5.0.51a-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> load data infile '/var/lib/mysql/e5publishers.txt'
    -> into table e5publishers
    -> fields terminated by ' ';
ERROR 13 (HY000): Can't get stat of '/var/lib/mysql/e5publishers.txt' 
(Errcode: 13)
mysql> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                 |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 
'*snip*' WITH GRANT OPTION | 
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> Bye
-bash-3.00$ ls -ld e5*
drwx------  2 mysql mysql   4096 Aug 15 01:34 e5
-rwxr-xr-x  1 mysql mysql 214256 Aug 15 01:30 e5publishers.txt
-rwxr-xr-x  1 mysql mysql   2641 Aug 15 01:30 e5servers.txt
-rwxr-xr-x  1 mysql mysql 178746 Aug 15 01:30 e5subscribers.txt
-rwxr-xr-x  1 mysql mysql 627939 Aug 15 01:30 e5topics.txt
-bash-3.00$ pwd
/var/lib/mysql
-bash-3.00$ ls -ld .
drwxr-xr-x  5 mysql mysql 4096 Aug 15 02:25 .
-bash-3.00$ ls -ld ..
drwxr-xr-x  24 root root 4096 Feb 16 10:02 ..
-bash-3.00$ ls -ld /
drwxr-xr-x  27 root root 4096 Aug 15 01:50 /
-bash-3.00$ ls -ld /var
drwxr-xr-x  22 root root 4096 Sep 16  2005 /var
-bash-3.00$ ls -ld /var/lib
drwxr-xr-x  24 root root 4096 Feb 16 10:02 /var/lib
-bash-3.00$ logout
[root@xd026 ~]# cd /var/lib/mysql
[root@xd026 mysql]# mv e5*.txt /
[root@xd026 mysql]# ls -ld /
drwxr-xr-x  27 root root 4096 Aug 15 02:26 /
[root@xd026 mysql]# mysql --user=root --password e5
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.0.51a-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> load data infile '/e5publishers.txt' into table e5publishers
    -> fields terminated by ' ';
ERROR 13 (HY000): Can't get stat of '/e5publishers.txt' (Errcode: 13)
mysql> Bye
[root@xd026 mysql]# ls -ld /e5*
-rwxr-xr-x  1 mysql mysql 214256 Aug 15 01:30 /e5publishers.txt
-rwxr-xr-x  1 mysql mysql   2641 Aug 15 01:30 /e5servers.txt
-rwxr-xr-x  1 mysql mysql 178746 Aug 15 01:30 /e5subscribers.txt
-rwxr-xr-x  1 mysql mysql 627939 Aug 15 01:30 /e5topics.txt
[root@xd026 mysql]# rpm -q -a | grep -i mysql
mysql-query-browser-5.0r12-1rhel4
mysql-gui-tools-5.0r12-1rhel4
MySQL-server-community-5.0.51a-0.rhel4
MySQL-client-community-5.0.51a-0.rhel4
mysql-administrator-5.0r12-1rhel4
[root@xd026 mysql]# 


Mike Spreitzer
SMTP: mspreitz@stripped, Lotus Notes: Mike Spreitzer/Watson/IBM
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
Thread
ERROR 13 (HY000): Can't get stat of '/var/lib/mysql/e5publishers.txt' (Errcode: 13)Mike Spreitzer15 Aug