CODEWITHSUNDEEP
androidsqlitebackupdropboxrestore
Tom R.
Tom R.

Reputation: 71

How to backup/restore SQLite database on Android to Dropbox

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...

Upvotes: 5

Views: 10322

Answers (1)

Nachi
Nachi

Reputation: 4248

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.

Upvotes: 6

Related Questions