Hi. On Fri 2002-12-27 at 17:19:26 -0800, [EMAIL PROTECTED] wrote: > I looked through the documentation, but I couldn't find anything relevant > to this, so here goes... > > I have MySQL with databases running on a Solaris machine, and MySQL with > different databases running on an Irix machine. I want to integrate some > of the databases from the Solaris machine into the Irix machine (as the > Solaris machine will no longer be used).. Is there any simple way to do > this?
Look up mysqldump and mysql in the manual. You want to do something like this: targethost$ mysqladmin create new_database targethost$ mysqldump -h oldhost some_database | mysql new_database HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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