LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]
The LOAD DATA INFILE statement reads rows from a text file into a table at a very high
speed. If the LOCAL keyword is specified, the file is read from the client host. If
LOCAL is not specified, the file must be located on the server. (LOCAL is available in
MySQL 3.22.6 or later.)
Moreover u r missing the escape char "\" in the path
so jsut type the foll and tell me it works .
load data local inifile "c:\\text.txt" into table dbname.tblname fields .
Additionally u could use "c:/text.txt" . Notice the forward slash
cheers
Sajan
----- Original Message -----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001 4:30 PM
Subject: Security Question
Hi,
I am typing the following sequence of commands and running into an access
denied message.
mysql -uusername -ppassword -hwww.myhost.com dbname
the bit above works and takes me to my mysql prompt and i am logged into my
server/database.
then i try the following and i get the error message.
load data local inifile "c:\text.txt" into table dbname.tblname fields
terminated by ',' ;
I have also tried ... infile "text.txt" and placed a copy of the text file
in c:\mysql and c:\mysql\bin with no success.
please could you let me know if you can see I am doing something wrong or
if there is a way I can check to see if I have relevant access before I
contact my ISP.
Many thanks
Sean Browne.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php