Amit,
Perhaps try running your LOAD DATA INFILE statement typed at the
command prompt of the mysql client, and maybe you will get more info as
to what the problem is. You may have a MySQL installation where the
'LOAD DATA INFILE' statement is not permitted by default.
However, these are just guesses. For future reference, please
be sure to provide a meaningful subject line to your posting, and give
us as much information as possible regarding the version of MySQL you
are running, which platform you are running on, etc. Thanks, and best
of luck.
Sincerely,
--
Barry C. Hawkins
Systems Consultant
All Things Computed
[EMAIL PROTECTED]
-----Original Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
sql.com]
Sent: Friday, April 26, 2002 3:57 AM
To: [EMAIL PROTECTED]
Subject:
Hi All,
Can someone help me figure out the following problem.
If i fire the following command from
D:\mysql\bin> mysql --user=netaps --password=netaps --host=192.168.100.2
--port=3306 --database=netaps --execute="LOAD DATA INFILE
'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE jobsequence FIELDS
TERMINATED BY ','";
It generates the following error:-
ERROR 1045: Access denied for user
netaps@NETAPS1(Using Password: YES)
but now if i executete command as :-
mysql --user=netaps --password=netaps
--host=192.168.100.2 --port=3306 --database=netaps --execute="select
count(*) from jobbatch";
It works fine.
Plase Help
REgards
Amit
__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
