Error Loading Text File into Table

01010011 · #1 (**permalink**) 11-14-09, 19:30

Hi,
I keep getting the error message:

Quote:

ERROR 2 (HY000): File 'fileName.txt' not found

whenever I try to load data from a text file (saved on path C

into a table like this:

Quote:

LOAD DATA LOCAL INFILE 'fileName.txt' INTO TABLE tableName;

I've also tried:

Quote:

LOAD DATA LOCAL INFILE 'C:/fileName.txt' INTO TABLE tableName;

and

Quote:

LOAD DATA LOCAL INFILE '/fileName.txt' INTO TABLE tableName;

but I keep getting the same error.

Now I've been reading about the security issues related to LOAD DATA LOCAL at:

Code:

http://dev.mysql.com/doc/refman/5.1/en/load-data-local.html

which suggested that LOAD DATA LOCAL can be enabled using:

Quote:

--local-infile[=1] option

My question is, how do I input this command?

Any assistance will be appreciated. Thanks.