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