merge? replicate? synch? federated tables? mysqldumps?

[fdelval]

Hi,



I have 3 client tables I would like to merge into a single one in the central server.


Those client tables won't have conflicting PK.




I thought of federated tables, but network sortages really ARE an issue, so I dismissed it. The approach should be able to store data locally, but send it to the server when available, and the server would store it altogether in a single table.



What would be the best approach to it?

I am using mysql.





Thank you