i am looking for some help regarding import and export of mysql tables. So here is my problem:
I have multiple tables in different locations. Lets say there is one server in dresden, another in england and another in düsseldorf. the name of the table is the same in these 3 locations. Let say the table name is "mactable" I need to pull all the data from this different locations into one database. This have to be done every time the user request for it. Each of this table can change at any time....
Is there any way of doing this?
Here are a test of the tables:
Dusseldorf:
--------------------------------
|Username | value | macaddress |
-------------------------------
|jose | 10 | 00:00:00:00|
--------------------------------
|maria | 20 | 00:00:00:01|
--------------------------------
Dresden:
--------------------------------
|Username | value | macaddress |
--------------------------------
|jose | 10 | 00:00:00:00|
--------------------------------
|maria | 20 | 00:00:00:01|
--------------------------------
|juan | 15 | 00:00:00:02|
--------------------------------
England:
--------------------------------
|Username | value | macaddress |
-------------------------------
|jose | 10 | 00:00:00:00|
-------------------------------
|maria | 20 | 00:00:00:01|
--------------------------------
|pedro | 20 | 00:00:00:03|
--------------------------------
Here you can see an example of what i am triying to do once i got all this tables in one database: http://www.sqlfiddle.com/#!2/8ca2f/1