Basically these two servers are not connected to each other. Also I am using win2k. I believe the syntax that you give me is in Unix. So I am thinking I should use the dump text file.... sorry not providing enough info... Thanks thought.
Andrew ----- Original Message ----- From: "Jason Yates" <[EMAIL PROTECTED]> To: "Andrew Chan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 1:04 PM Subject: Re: question > Easy, =) > > mysqldump <database name> -p<password> | mysql <database name> -h > 192.168.1.1 -p<password> > > That will dump the database and remotely insert in to the other server. > > -Jason > > On Wed, 2002-04-24 at 13:46, Andrew Chan wrote: > > Hello, > > > > I am trying to transfer tables/data from one server to another, say server A > > to B. mysqldmup helps me to dump table structure and data from server A. > > Wonder what command I should use to load those dump result into server B. > > Both server A and B are using the same version of MySQL. > > > > Any help is appreciated. Thanks. > > > > Andrew > > > > > > --------------------------------------------------------------------- > > 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