Hi,
I have a lot of databases that have the exact same tables and each table has
the exact same column structure. I'm looking at merging two of these
databases together into a single database (Company A bought Company B and
wants the data from A combined into B now).
I've been tossing around the
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Monday, May 11, 2009 3:30 PM
To: MySQL General List
Subject: Merging Databases
Hi,
I have a lot of databases that have the exact same tables and each table has
the exact same column structure. I'm looking
Withers [mailto:joh...@pixelated.net]
Sent: Monday, May 11, 2009 3:30 PM
To: MySQL General List
Subject: Merging Databases
Hi,
I have a lot of databases that have the exact same tables and each table
has
the exact same column structure. I'm looking at merging two of these
databases together
On 11-May-09, at 2:09 PM, Johnny Withers wrote:
We don't want to use a view because then this database will not
be consistent with the others.
We can't simply use a select from .. insert into because when we
renumber
table1's ID column, items in table2 and 3 and so on may link to the ID
, Craig (OFT)
Cc: MySQL General List
Subject: Re: Merging Databases
We don't want to use a view because then this database will not
be consistent with the others.
We can't simply use a select from .. insert into because when we
renumber
table1's ID column, items in table2 and 3 and so on may link
Hope this is the right term ;-)
Background:
I log my radius logs to mysql
I had a problem (self inflicted) with the table where I logged it into.
I copied the files out and recreated the database so that I don't ose to
many logs.
I took the old files .MYDetc and recreated the database on
Dear all,
it's our first time to realize a project, based on mySQL Database and now
we have a problem i hope we can solve easily.
There are different partners in this project and the actual solution is
based on a MS-Access Fronten (arrrggh!). Now the partner have to do some
input and they all
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
1 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