Re: Load Data Local Infile

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" <michael.mason@arraspeople.co.uk> wrote in message news:20040902091829.33767.qmail@pb1.pair.com... >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 > -----------------------------