Using LOAD DATA LOCAL INFILE

[viksha]

I am using phpMyAdmin 2.2.6 with MySQL 3.23.41 and trying to update the data of a table from the local database, I am trying the following with phpMyAdmin for this

LOAD DATA LOCAL INFILE 'c:/table.txt' REPLACE INTO TABLE oldone
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'

But it gives me the following error

MySQL said:

File 'c:/table.txt' not found (Errcode: 2)

While the file is right there in the location. What could be the reason and how to overcome this could anyone please explain this??

Thank You

 

[sleipnir214]

It's the "infile" clause of your query.

"Infile" is used when the datafile resides on the client machine, not the server machine.

If your datafile is on the server machine, drop the keyword "infile" from your query.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[viksha]

Yeah, I have the datafile residing in the client machine But still gets this error.