inserting a text file from sql

[tedpottel]

Hi
I got this sql line
LOAD DATA LOCAL INFILE '/LOAD DATA LOCAL INFILE '/public_html/ted/database.CSV' INTO TABLE testINTO TABLE test

I get a error saying cannot fine file.

the ftp shows the fike being at
/public_html/ted/

can sombody tell me how the file naming works.

Ted

[Silmaril8n]

You need to give it the full path which doesn't start with "/public_html/". It should be "/home/username/public_html/". Someone else had a recent issue that that and they had /home2/ instead of /home/. Try both.

[tedpottel]

Thank you for replying,

It still wont work
the ftp address is
public_html/ted/database.CSV
I tried
'home2/superme/public_html/ted/database.CSV'
and
'home1/superme/public_html/ted/database.CSV'

I got a file not found error.

Currently I'm doing it from the sql admin. Should that make a diffrence??
supreme is my login user name to the control panel, is that correct?

Ted