If all tables name are unique, and if you can bear the downtime, just shut
down the server and copy the files of one of the database to another
database will do
----- Original Message -----
From: "Andrew Dennison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 11:21 PM
Subject: merging databases
> What would be the best way to take two separate databases, and merge them
> together into a third database? From the discussions i've read, it seems
> that dumping them both, then importing them to this new database might be
> a way of doing it, but is a good way? will it work? Can you suggest a
> better way, or any problems with this way?
>
> 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
