sqlcipher: https://github.com/sqlcipher/sqlcipher
Open an encrypted database with a string key and a hex key.
|
1 2 3 4 |
$ sqlcipher encrypted.db sqlite> PRAGMA key = 'this-is-key'; sqlite> PRAGMA key = "x'DEADBEAF'"; sqlite> .tables |
Dump an encrypted database encrypted.db to plaintext.db.
|
1 2 3 4 5 |
$ sqlcipher encrypted.db sqlite> PRAGMA key = "x'DEADBEAF'"; sqlite> ATTACH DATABASE 'plaintext' AS plaintext key ''; sqlite> SELECT sqlcipher_export('plaintext'); sqlite> DETACH DATABASE plaintext; |
Dump many databases
|
1 2 3 |
for i in $(ls); do sqlcipher $i "PRAGMA key = \"x'DEADBEAF'\"; ATTACH DATABASE 'plaintext/$i' AS plaintext key '';SELECT sqlcipher_export('plaintext');DETACH DATABASE plaintext;"; done |
sqlcipher decrypt database by @sskaje: https://sskaje.me/2018/01/sqlcipher-decrypt-database/
Link to this post!