-macbook:sqlTest user1$ sqlite3 sqlTest.sqlite
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> ATTACH DATABASE 'encrypted.sqlite' AS encrypted KEY 'testkey';
sqlite> SELECT sqlcipher_export('encrypted');
Error: no such function: sqlcipher_export
sqlite>
sqlcipher_export() is missing function. Please help me
$ ./sqlcipher sqlTest.sqlite
$ /full/path/to/sqlcipher/sqlcipher sqlTest.sqlite
--
---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
./sqlcipher plaintext.sqlite
QLCipher version 3.8.0.2 2013-09-03 17:11:13
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> ATTACH DATABASE 'encrypted.sqlite' AS encrypted KEY 'testkey';
sqlite> SELECT sqlcipher_export('encrypted');
sqlite> DETACH DATABASE encrypted;
After command above,
plaintext.sqlite file size is getting zero byte and encrypted.sqlite getting 1 KB.
$ ./sqlite3 encrypted.db
sqlite> PRAGMA key = 'testkey';
sqlite> ATTACH DATABASE ‘sqlTest.sqlite’ AS plaintext KEY '';
sqlite> SELECT sqlcipher_export('plaintext');
sqlite> DETACH DATABASE plaintext;
After Decrypt to plaintext
plaintext.sqlite size is zero byte. contain tables are missing.
What is issue?