On 26 Jan 2011, at 2:08pm, Paul Sanderson wrote: > I have an sqlite database and an assocaiated .journal file that I need > tolook at. I have estalished that there is data in the journal that > seems relevant and want flush the journal (if that is the correct > term) and to then view the tables with the updated data. Is there a > way to do this?
Use any program that uses the standard SQLite routines to open the data file -- for example the sqlite3 command-line tool. The application will automatically recover anything that can be recovered from the journal file. If you need to distinguish between stuff in the database and stuff in the journal, take copies before doing anything, and open a copy of the database from a folder where you have /not/ copied the journal file. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
