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?
[EMAIL PROTECTED] ~]# 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 [EMAIL PROTECTED] |
+----------------------------------------------------------------------------------------------------------------------------------------+
| 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
[EMAIL PROTECTED] ~]# cd /var/lib/mysql
[EMAIL PROTECTED] mysql]# mv e5*.txt /
[EMAIL PROTECTED] mysql]# ls -ld /
drwxr-xr-x 27 root root 4096 Aug 15 02:26 /
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] mysql]#
Mike Spreitzer
SMTP: [EMAIL PROTECTED], Lotus Notes: Mike Spreitzer/Watson/IBM
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
