MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Francisco Reinaldo Date:July 5 2002 2:55pm
Subject:Re: Need Help with mysqlimport please-urgent!
View as plain text  
I am not sure if I understand your issue, but if the
tables have been updated in the local computer is
because you did not connect to the server. With
mysqlimport you can specify the host (-h), the user
name and password.

I think that you should use something like:

mysqlimport -hMYSERVER -pMYUSER -uTHEPASSWORD ...

Make user that the user has rights to connect to that
server.

Good luck!
--- ericloe@stripped wrote:
> 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 --local
> --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?
> Also if i specify --local i think that would be the
> issue.however if i
> remove the --local then i get an error saying
> something like 'this mysql
> version does not support or something like that'
> 
> 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).
> 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
> <mysql-thread113833@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-frsgti=yahoo.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
Thread
why some 0 size left in /var/tmpXiaoxia Zhao24 Jun
  • Re: Need Help with mysqlimport please-urgent!Francisco Reinaldo5 Jul
  • Re: Need Help with mysqlimport please-urgent!Gerald R. Jensen17 Jul