Staggan

Hello There are currently 5 databases.... I thought MySQL used to allow a restore that was additive... as in would append records to existing tables, if those tables existed... Ideally I want something that I can just name dbase 1 as source and dbase 2 as destination.... and add dbase 3 to that result...

Hello I have multiple copies of a database schema, all with separate data... I now want to merge all of this data into one location... I have prepared all the individual databases so there is no clash of any unique ID's etc... but I cannot find anything that will allow me to append the data from one database to the other... For example.. I have a table called user and another called purchases... this table exists in each database... But now I want to merge that data into a single place... I know I can do it table by table, but that is slow and if anything goes wrong it could take a long time to resolve... Are there any automated tools I can use ? Thanks