#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Denmark
    Posts
    82
    Rep Power
    15
    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
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    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...
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Denmark
    Posts
    82
    Rep Power
    15
    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
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Netherlands
    Posts
    77
    Rep Power
    15
    <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

Similar Threads

  1. FreeBSD help for a newb
    By matteorr in forum BSD Help
    Replies: 18
    Last Post: April 20th, 2004, 10:16 AM
  2. Replies: 2
    Last Post: February 6th, 2004, 07:25 AM
  3. Import text file into mysql
    By cmetzke in forum PHP Development
    Replies: 4
    Last Post: January 17th, 2004, 12:51 PM
  4. mysql query to tab delimited file?
    By direwolf in forum PHP Development
    Replies: 1
    Last Post: January 17th, 2004, 01:46 AM
  5. The term "keyword' was not found in any file
    By flashroiem in forum PHP Development
    Replies: 2
    Last Post: January 15th, 2004, 06:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo