Load data and pathname [SOLVED]
Posted: Tue Aug 16, 2011 10:11 pm
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.)
$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.)