[PHP] Importing data from one mysql server to an other

I'm working on a project that collects data from different mysql servers, combines the data and then displays it. My problem right now is the collection part. I have two ideas: 1st, write a php script that is placed on the webserver where the database is. Every time my webpage is opened, it co

[PHP] Importing data from one mysql server to an other

I'm working on a project that collects data from different mysql servers, combines the data and then displays it. My problem right now is the collection part. I have two ideas: 1st, write a php script that is placed on the webserver where the database is. Every time my webpage is opened, it co