MySQL/PHP Import once few hours data from 7 VPS servers to the main Server

I have 7 VPS running XAMPP localhost.
On those I have MySQL database with 9 tables each

I need this data from those tables set to the main Server which is not a VPS - it is a normal CentOS web server.

Now I manually export the data in .csv file from each table and then import them to the MAIN server.

I need it done either as a php file which will run on those VPS server and send data to the MAIN server or somehow else so I do not do it manually

When applying please tell me if you will make a php file or other solution

It is a simple job for someone experienced - I need it today/tomorrow.

Thx :)