I have a database in android app and i like to sync this sqlite db with mysql master in internet.
What is the best way to resolve this problem?
-dump in a file, upload file using web services -dump in a file, upload with ftp and then cron - any others?
Thankz
If its a one-time upload, use the dump-to-file aproach. Send it to server and parse it there.
If you have to keep syncing, then use a web-service api, and that too use as sparsely as possible - collect a lot of data and then sync, or on an as-needed basis. Focus to use as less data and battery as possible.