Best Practices Syncing large quantities of Information

Question

The question is relatively simple.

I have copies of a database that run on user computers in MySql and I have a server database that aggregates the information that is stored in this client database when the user wants to 'Sync' that information with the server.

Call the big Server databse server call the databse stored on the computers client

So I am going to be sending information from the client to the server and from the server to the client. Is there any reason why I would not want to send information from the client to the server as a file with all the sql statements that have been executed on the client.

So lets say that in the client I make some updates, inserts, and deletes. I record all those statements that get processed and send them up. Like a mysql dump.

I guess my only concern is problems with bringing information back down that has been modified already on the tablet but I will have to deal with this no matter how I send the information.

Answer 1

Is there any reason why I would not want to send information from the client to the server as a file with all the sql statements that have been executed on the client.

What if I put a nice DROP TABLE table or similar in the SQL statement? You won't be able to avoid that unless you have some sort of filter before everything goes into your master database. But I would not recommend something like that.