hmm, assuming only nullable columns are added and no existing colums / tables changed name, I would guess a data-only (no create/delete table scripts) dump of database 2 would fit in database 1 no?
As long as you use --complete-insert as parameter to make sure mysql adds the column names for the insert statements of the database 2 data I don't see a problem for those insert statements not to work on database 1.
The way things are now my production database is a subset of my development database scheme since my development sql contains all the same table and columns as the production database (and then some additional columns and tables).
I know I can import a mysqldump but this results in using the imported scheme.. id like to say "hey import everything but use the existing scheme of our destination".
in mathmatical terms you basically have two sets here..
let A be my production database, and B be my development database.
set A is a subset of B.
The function from A to B is one to one BUT NOT onto.
the function is just using the same table names and column names and matching them up in set A and B.
No built in method of mysql for doing this?
Edited by Pally, 20 August 2013 - 07:09 AM.