On 21 Dec 2009, at 3:12pm, Jay A. Kreibich wrote: > Make a copy of the database file. Run the VACUUM command on the copy. > If the data is gone from the raw file dump, it has already been deleted > from the database structure.
Alternatively you could use the command-line tool included with sqlite3 to inspect the contents of the database. This is probably already included with whatever OS you're using. http://www.sqlite.org/sqlite.html See whether the command-line tool reveals this data. If it does, there's something wrong with your viewing tool. If it doesn't, it's data which has been deleted and the space just hasn't been reused yet. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users