Re: [PHP] Re: Load Data Local Infile

2004-09-03 Thread raditha dissanayake
Harlequin wrote:
Dark forces indeed...!
Any ideas guys...?
 

someone in a mysql list might have.
--
Raditha Dissanayake.

http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload
Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader
Graphical User Inteface. Just 128 KB | with progress bar.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP] Re: Load Data Local Infile

2004-09-02 Thread Harlequin
Dark forces indeed...!

OK, OK... Now I have got it working using a local file on the HDD. Next - 
integration with PHP:

using the following syntax:

$Upload=
  LOAD DATA LOCAL INFILE '/public_html/CSVFILENAME.CSV INTO etc

does not seem to work and provides no error even though I'm trapping any.

I have a commend that changes the file permissions to read only ALL but 
still no joy.

If I use a local file, fine such as C:\CSVFILENAME.CSV but not the above 
path (and I checked, the file's actually there sitting and waiting). 
Strange.

Any ideas guys...?

-- 
-
 Michael Mason
 Arras People
 www.arraspeople.co.uk
-
Harlequin [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
I am using the following command and it appears to execute but does not 
actually load any data:

 LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE 
 MembersData
 FIELDS TERMINATED BY ','
 LINES TERMINATED BY '\n';

 Any ideas what I might be missing...?

 The file exists, and I must have the path right or would get an error but 
 still no joy unfortunately...

 -- 
 -
 Michael Mason
 Arras People
 www.arraspeople.co.uk
 - 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php