Strange MySQL error

Anon

Hi, I'm running a PHP script on a Unix server using MySQL, the error I get is:

13: Can't get stat of '/path/film.txt' (Errcode: 2)

What could be the meaning ?

The error happens when I try to run the command from a PHP script, if I load the same istruction from Telnet session it works... the command is:

LOAD DATA INFILE '/path/file.txt' INTO TABLE tablename FIELDS TERMINATED BY '^' ENCLOSED BY '#'

Thank you

Anon

Can't get stat = file not found.

make sure the file exists where you claim it to be and make sure the user that runs php/mysql has acces to read the file.

Anon

The file doesn't exists.

Probably your path is wrong of incomplete, but, as Vincent said, make sure that your user has proper privileges.

lancelot_

Anon

Thank you for both answers,

well the path is right, before to call the LOAD DATA function, the file is copied to that location (and I see that is there), than LOAD DATA function should be performed and than the file is deleted... first and thirth step are performed correctly, not the second...

I think the permissions are ok... what do you think about?
thank you

Anon

The first and third step are performed by PHP, the second is performed by MySQL.

Did you try putting the file into the /tmp directory to see if that works?
/tmp is usually writable by everybody.

Anon

Grat idea!

I have tryed once more but I get the same error :-(

So now I am trying to find the way to load the file from cliet machine using the command:

LOAD DATA LOCAL INFILE ...

the problem I have now is that I don't know how to get the local path of the file: I have a <input type="file" name="file"> box where user selects the file, but I don't know how to copy the path... I should be better if it could be variable or I must set a fixed path like c:\file.txt ...

The variable $file will return the path on server Unix :-(

Could you give me some more help ?

thank you

Anon

I get the same error! I think though that it has to do with the location of the file in respect to the script. I have a script that lists the contents of a directory in my file system. It works fine as long as the script is in the same directory that I am making the list from, I get the error when I try to list the contents of another directory. It list the contents, but gives the error before each list item.

However, I am kinda new to all of this, it could be me paths permissions etc... The frustrating part is that the script lists the contents like it should, creates links and even work when I click on one of the links, I just have error messages that say "stat failed for somefile.ext"

Anon

It is probably looking on the server where mysqld runs for the file, not on the machine that runs the client, can this be???