Bug #20632 I use the LOAD DATA INFILE command and I got ERROR 13 (HY000)

• Submitted: 22 Jun 2006 16:56
• Modified: 22 Jun 2006 19:49
• Reporter: Rosa Morales
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• OS: MacOS (Mac OS X Version 10.4.5)
• CPU Architecture: Any

[22 Jun 2006 16:56] Rosa Morales

Description:
Hi,

 I am using a mysql server version: 5.0.22-max. I am trying to load data in a
mysql table using:

 LOAD DATA INFILE 'Users/rosamorales/Documents/etc/1990list.txt' INTO TABLE
first_list FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n';

 and I got the following error message:

 ERROR 13 (HY000): Can't get stat of
'/usr/local/mysql/data/Users/rosamorales/Documents/etc/1990list.txt' (Errcode:
2)

Then I tried to disable SELinux By using: /usr/sbin/setenforce Permissive;

and I got the following message:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'/usr/sbin/setenforce Permissive' at line 1

How to repeat:
LOAD DATA INFILE 'Users/rosamorales/Documents/etc/1990list.txt' INTO TABLE
first_list FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n';

[22 Jun 2006 19:49] Hartmut Holzgraefe

We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.