Bug #14014 Problems in loading textfile into a table
Submitted: 13 Oct 2005 18:49 Modified: 13 Oct 2005 21:04
Reporter: Swaroop Kumar Tata Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:GNU bash, version 3.00.16(1)-release (x8 OS:GNU bash, version 3.00.16(1)-rel
Assigned to: CPU Architecture:Any

[13 Oct 2005 18:49] Swaroop Kumar Tata 
Description:
Hi,

  I have problem while loading a textfile into a table. Below i am pasting the details.

mysql>load data infile "/home/campaignmanager/www/cgi-bin/cronjobs/SORT_ALL_acct_AGH001_angleshold.txt" ignore into table pbounce_trafficvenue_emails(email_id);

ERROR 13 (HY000): Can't get stat of '/home/campaignmanager/www/cgi-bin/cronjobs/SORT_ALL_acct_AGH001_angleshold.txt' (Errcode: 13)

I have checked for the following:

1.> Permissions are given but no use.

2.> I have checked for existance of the textfile

Please help.

Regards / Thanks

Swaroop Kumar. Tata
Ybrant Technologies (I) Ltd., Hyderabad
Mail: swaroop@ybrant.com  |  swaroop@ybrantinc.com
Ph: 09346200133

How to repeat:
Load the textfile into the table. and check
[13 Oct 2005 21:04] Hartmut Holzgraefe 
Error code 13 is:

> perror 13
OS error code  13:  Permission denied

so i'm afraid you have to check the permissions again.

Please remember that LOAD DATA INFILE is performed by the mysql server process
(unless you add LOCAL), so the user the mysqld process is run at has to be able to
read the file, not your local user