Forum

Try LOAD DATA LOCAL INFILE

Without that, I believe, the file needs to be relative to your mysql folder (or data folder?). Not sure.

Quoted from Schis

LOAD DATA INFILE ‘C:xamppolle.txt’ INTO TABLE `djur`

error: #29 – File ‘C:xamppmysqldataxamppolle.txt’ not found (Errcode: 2)

HALP!

Not sure if i’m missing something here, but where are the slashes in the path?
If you’re using backslashes you need to double them up, or just use forward slashes.

By the way, “local” specifies that it should be read from the client, rather than the server.

Use “LOAD INFILE” and mysql_real_escape_string($filepath)

Quoted from Miek

[…]
If you’re using backslashes you need to double them up, or just use forward slashes.

This, for windows.