Hello,
Here is my problem, I would like to use mysqlimport (which i
have compiled as a batch file to run) from a client side to load data onto
the database on a server side, meaning that I would normally access my
server through the pc and running the batch file. Problem is that there are
no errors but the tables on the server side does not get updated but
instead points to updating my local database, data are loaded into my
tables instead (i have the exact replica database on my own pc). Here is a
sample command line from my batch file
@h:\mysql\bin\MYSQLI~1.EXE --replace --host=host_name --user=root
--fields-terminated-by="," --fields-enclosed-by="\"" --lines-terminated-by
="\r\n" BO h:\mysql\data\BO\outnum
i've mapped h:\ as pointing to the c:\ of my server..is that possible?
[The error relates to 'access denied for @pc_id (i think its the same
network id used for login to a NT domain) to BO database' or at times 'the
mysql does not support this version']
P.S. My table name is outnum which is the same as the file name, MySQL
version is 3.23.51.
What am i doing wrong here? Need help please (could someone guide me what
to do from the very beginning. I need to run mysqlimport as if i'm running
any program from the console itself but only from a remote terminal). To
simplify, what i need here is a way to run mysqlimport from my pc to pump
data into the tables on the MySQL server instead of the data being thrown
in my local MySQL server.Urgent! Thank you.
Regards,
Eric Loe.
**************************
NOTICE OF CONFIDENTIALITY
**************************
This message and any files transmitted with it may be privileged and/or
confidential and are intended only for the use of the addressee. If you,
the reader of this message, are not the intended recipient, you should not
disseminate, distribute or copy this message. If you have received this
message in error, please notify us immediately by return email and delete
the original message. Thank you.
---------------------------------------------------------------------
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
