How to backup/restore SQLite database on Android to Dropbox

Question

I am currently developing an Android application which makes use of the SQLite database. I am looking for ideas how to backup/restore the database to and from external services such as Dropbox. I have gone through some explanations such as below:

Android backup/restore: how to backup an internal database?

Backup/restore sqlite db in android

These explanation are mainly about backing up locally, but I want to backup to cloud, as I mentioned, something like Dropbox.

Help please... Thanks in advance...

Answer 1

Using the answer here, you can get a reference to your database in the form of a .db File object.

final String inFileName = "/data/data/<your.app.package>/databases/foo.db";
File dbFile = new File(inFileName);

Once you have this, it's easy to read/write to a user's Dropbox using the Dropbox Sync API.

• Backup: Use writeFromExistingFile() to write this local File to the Dropbox directory
• Restore: Use getReadStream() to get a FileInputStream that can write to the appropriate local path where your .db file goes.