sqlcipher how to import a sqlite3 database

Question

I have dumped a sqlite3 database into a .sql file. Afterwards I have import the files like this:

cat databasedump.sql | sqlcipher encrypted_database

Then I've opened the encrypted database and set the key with:

pragma key="12345"

then I close the database and reopen it, it's still not encrypted.

How can I load the dump in the database and encrypt it?

coleifer · Accepted Answer · 2015-08-20 02:36:52Z

1

$ sqlcipher plaintext.db
sqlite> ATTACH DATABASE 'encrypted.db' AS encrypted KEY 'my password';
sqlite> SELECT sqlcipher_export('encrypted');
sqlite> DETACH DATABASE encrypted;

answered Aug 20, 2015 at 2:36

coleifer

26.4k7 gold badges67 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shibumi Over a year ago

This works, but how can I decrypt the database? Normally its pragma key='my password'; but it's not decrypted afterwards I just get the following message: Error: file is encrypted or is not a database. I see only the similiar way back.. so attaching new databas.. decrypting.. selecting.. detaching.. etc. Is there a way to decrypt it and load it directly in ram?

wolfman · Accepted Answer · 2015-09-14 18:29:00Z

1

$ ./sqlcipher encrypted.db
sqlite> PRAGMA key = 'my password';
sqlite> ATTACH DATABASE 'plaintext.db' AS plaintext KEY '';  -- empty key will disable encryption`
sqlite> SELECT sqlcipher_export('plaintext');
sqlite> DETACH DATABASE plaintext;

answered Sep 14, 2015 at 18:29

wolfman

112 bronze badges

Collectives™ on Stack Overflow

sqlcipher how to import a sqlite3 database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related