sqlcipher decrypt database

By @sskaje
Link: https://sskaje.me/2018/01/sqlcipher-decrypt-database/

sqlcipher: https://github.com/sqlcipher/sqlcipher

Open an encrypted database with a string key and a hex key.

$ sqlcipher encrypted.db
sqlite> PRAGMA key = 'this-is-key';
sqlite> PRAGMA key = "x'DEADBEAF'";
sqlite> .tables

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

$ sqlcipher encrypted.db
sqlite> PRAGMA key = "x'DEADBEAF'";
sqlite> ATTACH DATABASE 'plaintext' AS plaintext key '';
sqlite> SELECT sqlcipher_export('plaintext');
sqlite> DETACH DATABASE plaintext;

$ 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

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

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/

Related posts: