MySQL said: File '\php2' not found (Errcode: 2)

Hi
I get the following error, when I try to insert at txt file.

MySQL said: File 'php2' not found (Errcode: 2)

I don't get the error message on my "localhost" - only when I try to install the same text-file on a remote server.

If you have seen or solved this problem, please reply.

Thanks in advance

Jens Jakobsen

are you giving the full path to your text file in the load infile command?

what is the exact command you're giving to mysql to try and load the text file?

---John Holmes...

Sorry I diden't explain what I was doing.

I get the error when I try to insert the textfile from "phpMyAdmin"!

Hope you can help me out.

Best regards
Jens

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by bee:
Sorry I diden't explain what I was doing.

I get the error when I try to insert the textfile from "phpMyAdmin"!

Hope you can help me out.

Best regards
Jens[/quote]

I think it has to do with PHP running in safe mode, or it could be that the temp directory has not been defined in the ini file on the server.
In PHPMyAdmin you have to upload a file to import into MySQL. If PHP is installed in safe mode, then this is not permitted (it is not permitted to access files in the temp directory). Try the function phpinfo() and you'll see an overview of PHP settings and whether or not a temp directory has been set.

Try to contact your serveradministrator and ask if they can install PHP without the save mode. I had the same thing once.

Good luck, Peter