On 28 Jan 2015, at 3:15pm, Mario M. Westphal <m...@mwlabs.de> wrote:
> The damage is usually detected during “diagnosis” runs. This feature runs an > “analyze” and a” vacuum” command in order to physically validate the database > (and to optimize and compact it). Please don't do that. Neither of those things does any diagnosis on the database. And they both make changes which can complicate damage or cover it up and let it happen again. The command PRAGMA integrity_check checks your database for faults. That's the way to detect faults and tell whether there really is a problem with your database. <http://www.sqlite.org/pragma.html#pragma_integrity_check> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users