I run a game community (with servers). I have two hosts, the first one is the "community" host which pretty much hosts the website/forums/etc, in the other host I run my game servers, along with a MySQL database containing playerdata.

In short, I want to create a ranking on the website based on the stats in the gameserver database. 

In order to not put much strain to the gameservers I was wondering if it's possible (with a Cronjob maybe?, to make it periodically) to create a dump of a specific SELECT query.

However I do not know how to use the SELECT INTO query to select data and insert it between remote servers.

Is there a way to accomplish this or I'm forced to use MySQL's Federated tables?

Thank you in advance