[racktables-users] Re: merge rackable instances?

Denis Ovsienko wrote:

One thing you can do is do a mysqldump, there are tools you can use such as 
phpmyadmin that can take down the entire racktables DB into a single sql file.


That wouldn't work most probably, because key values would clash. A
special script is required for this task, and there are two ways to do
it:
1. Mimicking an operator. Read rows from database B one by one and for
each generate a row in database A.
2. Mapping keys. For each database (A and B) compute its own range,
which covers values of all keys in all tables. Based on that offset keys
in one database by constant value and selectively dump records from it.
Import that dump into another DB. The keys won't go contiguous in most
tables, but all data will be consistent.
Is the database schema documented well enough somewhere to make sense of the data and the internal relationships? 

--
  Les Mikesell
   lesmikesell@xxxxxxxxx

Other related posts: