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