Quote:
Originally Posted by Ephemerality
How are you creating the new db? Are you including
Code:
PRAGMA user_version = 1;
in there somewhere? You can check, in SQLiteBrowser at least, under the Edit Pragmas section. If it's not 1, set it to 1, save, then see if it will load.
|
TL;DR
That worked. Thanks!
The way I made it was to run sqlite3 on the original db, then set output file to Wap.sql, did a .dump then did
sqlite3 XRAY.entities.B00JCDK5ME.asc < Wap.sql
in a directory that had no file named XRAY.entities.B00JCDK5ME.asc
As you suspected, user_version = 0
My sqlitebrowser at work has an Edit Pragmas tab, but I have no XRAY file there.
At home, sqlitebrowser doesn't have an Edit Pragmas tab so I just used sqlite3