ERROR 13 with load_data function on Linux

[Boniface]

I am currently porting our application to Linux but I am having problems loading our test data set into the MySQL database. I am getting an Error 13 when trying to load data using the load_data function.

I run out load script from the command line as:

mysql -u auser -papassword -D atestdb < load.sql

The script contains insert statements like:

INSERT INTO feature_vector VALUES (&quot;11682&quot;,LOAD_FILE(&quot;/home/mjb/fvs/test-data/sculpteur-tds/feature-vector/export_fv.txt1.out&quot,1003);

When run I get the following Error 13 message:

ERROR 13 at line 5: Can't get stat of '/home/mjb/fvs/test-data/sculpteur-tds/feature-vector/export_fv.txt1.out' (Errcode: 13)

o I have tested the script on Windows with no problems.
o All files have global permissions.
o The user has file privileges

Does anybody know of any issues that I have to be aware of to use the load_data function on Linux such as user ids and groups for the mysqld etc.

Thanks

Mike

 

[Boniface]

Sorted it, my initial load directory was mapped from my home area.

Move the data to /tmp solved the problem