Re: LOAD DATA INFILE - still confused
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]
Re: LOAD DATA INFILE - still confused
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]
Re: LOAD DATA INFILE - still confused
yes he is right i am doing the same. and giving full path. i have other problems with load data infile :( - Original Message - From: "Frank Bax" <[EMAIL PROTECTED]> To: Sent: Wednesday, June 08, 2005 1:39 AM Subject: Re: LOAD DATA INFILE - still confused > 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] > ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA INFILE - still confused
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]
LOAD DATA INFILE - still confused
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) The simple php script and the file, datafile.txt are both in the same directory. Where is MySQL looking for the file, datafile.txt? NOTE: the error reported indicates that MySQL is searching in for datafile.txt in a directory called mydatbasename. However, I am running the php script in a shared hosting environment and I am not able to view the directory mydatbasename (if it is actually a directory). Apparently the directory is outside my root? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]