Page 1 of 1

Load data and pathname [SOLVED]

Posted: Tue Aug 16, 2011 10:11 pm
by PHP_mySQL__Newbie
This may be an easy one but I am not able to figue it out. I am trying to load a data file but mysql is not able to recognize the path. What am I missing here?

$sql = "LOAD DATA LOCAL INFILE
'/localhost/Data/Table.txt'
INTO TABLE myTable IGNORE 1 LINES;
";

(Pardon my intrusion with a mySql posting. I am noticing that there are plenty of smart programmers on this forum as compared to other forums where there is not much going on. The posting sits there forever.)

Re: Load data and pathname

Posted: Tue Aug 16, 2011 11:12 pm
by PHP_mySQL__Newbie
ok. I figured it out.
This worked.

$sql = "LOAD DATA LOCAL INFILE
'http://localhost/Data/Table.txt'
INTO TABLE myTable IGNORE 1 LINES;