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
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.
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. ???
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.
I use SQLite Studio to open & browse the database files.
https://sqlitestudio.pl/index.rvt?act=download
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?
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.