hi, i am new to sqlite and i am trying to recover some data from a journal file into the main db - the db file doesnt contain all the records we would expect. I have opened the journal in notepad and i can see text so not sure what has happened?
I have tried:
this creates a empty 0kb db, no errors
Next:
This returns "Error: file is encrypted or is not a database"
Am i missing something? Many help appreciated
I have tried:
Code Select
sqlite3 control.db-journal .dump | sqlite3 recovered.dbthis creates a empty 0kb db, no errors
Next:
Code Select
sqlite3 control.db-journal
pragma integrity_check;This returns "Error: file is encrypted or is not a database"
Am i missing something? Many help appreciated