• Welcome, Guest. Please login.
 
August 19, 2019, 07:19:39 am

News:

Welcome to the SQLitening support forums!


sqlite journal recovery

Started by backtofront, July 07, 2013, 05:05:46 pm

Previous topic - Next topic

backtofront

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:
sqlite3 control.db-journal .dump | sqlite3 recovered.db
this creates a empty 0kb db, no errors

Next:
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