On Sunday, 18 August, 2019 11:10, 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. You probably did not actually "open" the file. The sqlite3_open* calls are lazy. The database files are not actually opened until they are needed for something, like you attempt to read or write from the file. The following does not actually "open" the file "test.db": sqlite3 test.db sqlite> .q However, the following will, since it requires actually reading something (the schema) from the database file, and to do that it must actually be opened: sqlite3 test.db sqlite> .schema sqlite> .q -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
