How to backup an encrypted database

SQLCipher Issues
1

I notice that 4.1 has disabled the Backup API.

What is the recommended way to backup an online database?

Thanks.

2

Hello @mtissington

The backup API will not work (nor did it previously) with a SQLCipher encrypted database. If you are operating on an encrypted database, the closest solution is likely through the use of sqlcipher_export(...).

[1] https://www.zetetic.net/sqlcipher/sqlcipher-api/#sqlcipher_export

3

OK - thanks - I’m curious before you disabled Backup API we were using it and it seemed to work just fine - how would we have seen the issue?

4

Hello @mtissington - it depends on how you were using the backup API. Some scenarios worked, but others would fail unexpectedly. How were you using it specifically?