-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 23/01/12 01:45, Sreekumar TP wrote: > Transactions are written to the WAL file, therefore, even if the WAL > file is lost, I should be able to retrieve the database without > corruption.(sacrificing some data ofcourse) ?
Correct. A checkpoint will end up modifying the main database file. However you need to identify how you got the corruption in the first place otherwise it will happen again. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8dP4oACgkQmOOfHg372QQdgACguIlWFuXuV3GPIfVWugf5RdbE oEAAnAhXDR6JH7W5nKCraNKYnpFEfYkl =VPyM -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users