On 21 May 2014, at 9:16pm, Drago, William @ MWG - NARDAEAST <[email protected]> wrote:
> Well, it finally happened. I had a program crash and was left with a hot > journal file. A while back there was a post by Richard Hipp detailing > something that could/should be done before trying to use the database to > assure that SQLite does the rollback. I can't find that post now. Nothing. Leave everything as it is. Do not move or rename the journal file. Just run whatever app it was that opens the database again. SQLite will automatically notice the hot journal file and do its best to restore the database to an uncorrupted between-transaction state. If you want to be extremely cautious take a backup copy of the database and the journal file before you reopen the database file. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
