積丹尼 Dan Jacobson wrote: > file:///usr/share/doc/sqlite3-doc/wal.html should mention the common case > where > the user (let's say someone from a different project) has encountered > cookies.db cookies.db-shm cookies.db-wal > left behind by some program. User wishs to clean this up, leaving only > cookies.db.
That page says: | When the last connection to a database closes, that connection does | one last checkpoint and then deletes the WAL and its associated | shared-memory file, to clean up the disk. From this, you can deduce how to clean up: close without crashing. > $ sqlite3 cookies.db .dump > /dev/null You could instead use any command that accesses the database: $ sqlite3 cookies.db 'begin immediate; rollback;' Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users