On 18 Aug 2019, at 6:10pm, Robert Weiss <weiss...@yahoo.com> wrote: > I had a process that was writing a sqlite database when the computer crashed. > I now have two files: f6.db and f6.db-journal. How do I get the information > in the journal file to be incorporated in the database? > I tried open f6.db in the sqlite3 console program, and afterwards the journal > file is still there.
That's okay. You did the right thing. If you use the console program to make a change to the database, then close it by quitting the SQLite CLI, /then/ the journal file may disappear. Do not delete, move or rename the journal file yourself. That will definitely make things worse. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users