Wrong path, you are referring to an uri, not a path. Way off topic to
starting explaining basic file system stuff here.
You should be the same path you used when your uploaded the
file. Something like:
/home/chris/datafile.txt
Frank
At 10:06 PM 6/7/05, Chris wrote:
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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]