SQLite database cipher

[recobb]

Howdy,

I exported one of my groups to an SQLite database.  I am now trying to use the SQLite Browser ( https://sqlitebrowser.org/ ) to open it, and I get a dialog box asking for the SQLCipher encryption key.  I tried using my yahoo password, but no joy.  There is also a page size field which defaults to 1024

How do I get past this?  I looked at the export dialog, and did not see any settings I could id as relevant there.

Thanks,

Richard

[Wilson Logan]

The "export" files, the PG4 files, are archive files. Not SQLite databases.

Open the .db3 file directly with SQLite Studio

https://sqlitestudio.pl/index.rvt?act=download


There are instructions in this forum to take an SQLite dump file and convert it to a MySQL dump file.

Someplace... search the forum for "dump file".

Cheers,

Wilson.

[recobb]

Thanks, but I think I'm missing something.  I selected a group that I had downloaded, then used the Export toolbar, selected "export as SQLite dump" and saved it as a .sql file.  That is what I am trying to open with the SQLite Browser.  ???

[Wilson Logan]

Hi Richard,

You can open the .db3 database file directly with SQLite Browser.

You do not need to export as SQL as what this produces is a dump file which is a text file of SQL commands.

You cannot open a text file with a utility designed to open databases.

Just open the .db3 file (which is an SQLIte database) using your SQLite browser.

Cheers,

Wilson.

[Wilson Logan]

I use SQLite Studio to open & browse the database files.

https://sqlitestudio.pl/index.rvt?act=download

[outboundlight]

How about if you exported your messages as a MySQL dump file? Can you open and browse those files in SQLite studio or do I need to go back and re-export my files as as SQLite files?

[Wilson Logan]

Anything you export as a dump is a text file.

Its a sequence of SQL commands to recreate the database.

You'd need an existing empty database to run the commands into.