同步mysql sqlite,同步数据库Mysql的SQLite的

I am wondering what is the best approach to updating a database on an Application.

We have a mysql database that handles everything on the main server, but I want to replicate this on my app. I would like to copy the database (mysql) on the android device so that both stay up-to-date. this would not have to happen in real time, but could be scheduled once every week, or when a change is made to the SQL database.

How would i do such a thing?

As in should I send this out as an update to the application and create the changed database, or should I use some way of getting the database to be changed on the server, and the SQLite data base be copied across to the android app.

Or ... is there some nice clever way of doing this??

Thanks

Pat

解决方案

Why not use a timestamp (or version field) in the mysql database on your server, then when the android app is run it imply checks the timestamp/version to see if there is a change since it needs to be updated. If the timestamp/version is newer than previously found download the updated dataset else simply use what is already stored.