> If you delete the database file then make sure you also delete any other > files that might have been associated with it, such as left over journals > and so forth.
I never see those extra files in practice. Are they guaranteed to be deleted automatically once an SQLite session is finished? Nope. If there was a problem in closing down they can hang around (which is their whole point for recovery). Also if a journal mode of "persit" was used. But mostly from incorrect closure. So check for any -journal, -wal, or -shm files of the same name if you want to obliterate a database. (Am I missing any others?) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users