Load Data can't find file

Roger_Ramjet

Help please. I'm running this in my script:

// load the file list from FileList.txt
	$sql = "LOAD DATA LOCAL INFILE 'N:\\\\Tracker\\\\Webloads\\\\LoadFiles.txt' INTO TABLE loadfiles FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '' LINES STARTING BY '' TERMINATED BY '\r\n'";							
	$result = mysql_query($sql) or die($sql . '<br />' . mysql_error());

and I'm getting this as the result

LOAD DATA LOCAL INFILE 'N:\Tracker\Webloads\LoadFiles.txt' INTO TABLE loadfiles FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '' LINES STARTING BY '' TERMINATED BY ' '
File 'N:\Tracker\Webloads\LoadFiles.txt' not found (Errcode: 2)

The file is there. I've got C:/ my.cnf with this in it

[client]
local-infile=1

on my PC.

Any ideas????

PS the actual script has 4 slashes, but they get stripped out with the php tags.

sanam

1) Which operating system are you running on; if windows it should look this:
N://Tracker/Webloads/LoadFiles.txt

ON unix/linux
N:\Tracker\Webloads\LoadFiles.txt

2)Try using single slash after root. You should always check if file exists before performing any operation on it.

// windows operating system
$filename = 'N://Tracker/Webloads/LoadFiles.txt';

if (file_exists($filename)) {
echo "The file $filename exists";
} else {
echo "The file $filename does not exist";
}

Roger_Ramjet

Thanks for the help sanam, but that's not it. I've tried every possible combination of \ and /: no joy.

By the way, are you sure about the use of // on Windows? Seems counter intuitive to me.

I'm investigating the Errcode 2 next. Seems to be a mysql config problem - no surprise given the way my provider has been operating of late.

Anyone with any ideas

sanam

Does your file resides on a mapped drive, if so in that case you should be looking into something else. Maybe ftp or how to access file on remote system. If you find a solution could you post it here.