MySQL Forums
Forum List  »  Newbie

Problem with load data in file
Posted by: g_p g_p
Date: October 05, 2008 04:47AM

Hello,

I'm typing in the "mySQL Command Line Client" the following commands in order to load data into a table

a)mysql> LOAD DATA LOCAL INFILE 'C:/Documents and Settings/ram.txt' INTO TABLE ram;
b)mysql> LOAD DATA LOCAL INFILE 'C:/Documents and Settings/ram.txt'
-> INTO TABLE ram
-> LINES TERMINATED BY '\r\n';
c) mysql> LOAD DATA LOCAL INFILE "C:/Documents and Settings/ram.txt" INTO TABLE ram;

The above commands generate the following error:
ERROR 2 (HY000): File 'C:\Documents and Settings\ram.txt' not found (Errcode: 2)
etc.

I have installed mysql-5.0.67-win32 and i have Windows XP.

Could you please help me?

Thanks



Edited 3 time(s). Last edit at 10/05/2008 04:48AM by g_p g_p.

Options: ReplyQuote


Subject
Written By
Posted
Problem with load data in file
October 05, 2008 04:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.