Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sync databases sqlite with mysql

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

like image 547
user1663513 Avatar asked Nov 13 '22 20:11

user1663513


1 Answers

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.

like image 79
Aswin Kumar Avatar answered Nov 15 '22 11:11

Aswin Kumar