I have several copies of the same application, each with a MySQL database, each identical except for some random characters before each table name as below:
What I would like is to take say table 2 of each database an import them into database X so we have
I can then point an application at this one database, rather than each of the individual databases, I can also change/add/remove the source databases buy just changing a script to point to the new/change/removed location.
As the version of the app will always be consistent across the environments I am hoping that there will be no issues with schema etc.
Firstly is this possible? Secondly if so what is the best way to do it, I assume a cron job or something on the target server, can this be run to limit the entries pulled back from the tables for a given period IE update the target database with new entries from the last hour.
Code:
db1 xxx_table1 xxxx_table2 xxxx_table3 xxxx_table4 db2 yyyy_table1 yyyy_table2 yyyy_table3 yyyy_table4 etc
Code:
dbx xxxx_table2 yyyy_table2 zzzz_table2
As the version of the app will always be consistent across the environments I am hoping that there will be no issues with schema etc.
Firstly is this possible? Secondly if so what is the best way to do it, I assume a cron job or something on the target server, can this be run to limit the entries pulled back from the tables for a given period IE update the target database with new entries from the last hour.
Comment