MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:°l||l°  Jinxed °l||l° Date:June 7 2005 10:54pm
Subject:Re: LOAD DATA INFILE - still confused
View as plain text  
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" <fbax@stripped>
To: <mysql@stripped>
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/mysql?unsub=1
>


	
	
		
___________________________________________________________ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail
http://uk.messenger.yahoo.com
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