MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Chris Date:June 8 2005 2:06am
Subject:Re: LOAD DATA INFILE - still confused
View as plain text  
Well, in fact I have read the documentation several times before posting
this note.

My problem arises because I don't know what is meant by full file path. If
you mean: 'http://www.mydomain.com/datafile.txt' that produces the error:
Can't get stat of 'http:/www.mydomain.com/datafile.txt' (Errcode: 2)

Also, using a php pre-defined variable such as  $_SERVER['DOCUMENT_ROOT']
creates the same error.

Oh, yes I do know about file permissions in the entire path. If I only knew
how to find the path, life would be much easier.


"Frank Bax" <fbax@stripped> wrote in message
news:5.2.1.1.0.20050607163743.03cfb420@ style="color:#666">stripped...
> At 03:59 PM 6/7/05, Chris wrote:
>
> >I have a simple php script which runs the following query:
> >
> >LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
> >TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
> >
> >which generates the error:
> >File './mydabasename/datafile.txt' not found (Errcode: 2)
>
>
> Didn't bother to read the manual did you?
>          http://dev.mysql.com/doc/mysql/en/load-data.html
>          >> file named as myfile.txt is read from the
>          >> database directory of the default database
>
> Specify the full path to your input file.  Life will be much easier.
>


Thread
LOAD DATA INFILE - still confusedChris7 Jun
  • Re: LOAD DATA INFILE - still confusedFrank Bax7 Jun
    • Re: LOAD DATA INFILE - still confused°l||l°  Jinxed °l||l°8 Jun
  • Re: LOAD DATA INFILE - still confusedChris8 Jun
    • Re: LOAD DATA INFILE - still confusedFrank Bax8 Jun