Android Question sqlcipher backup

[surfuric]

What is the best way to backup/restore a database being used with sqlcipher?

 

[Erel]

What exactly do you mean with backup and restore?

A local backup?

The database is stored as a single file (or as three files in some cases). You can make a copy of the database file(s).

 

[surfuric]

This is what I thought.

But when I searched on the internet, many said that just copying can lead to corruption (they were not specific as to why). As long as I close the database before copying I should be alright, is this the case?
I use File.Copy for the copy, nothing else special.

Also, I do not seem to have a journal file in my directory, just a .db file. So I was worried that sqlcipher might have different requirements.

 

[Erel]

is this the case?

Yes.

Also, I do not seem to have a journal file in my directory, just a .db file. So I was worried that sqlcipher might have different requirements.

There will only be additional files if the journal mode is wal. You can check it with a pragma query.

 

[surfuric]

Great, Thanks!