Hi, Pavan, Regarding: "In a situation where if the sqliteDB gets corrupted is there a way to recover the data ? I understand that the word *corrupted* is too generic from technical point of view. But, still would like to know if anyone has faced a situation where indirect methods are used to retrieve data from DB."
I think the general advice goes something like this: 1) After a power outage or system crash, be sure to let sqlite attempt to bring the DB to a consistent state using its journal. 2) If the DB then asserts that it is corrupted, make a copy of it for safety, than attempt a VACUUM command. 3) If the DB still asserts corruption, use the command line utility and attempt to .DUMP individual tables. 4) Resort to your backups if all else fails. And for the future, make sure you're not using "PRAGMA synchronous = OFF;" for any data you care about losing. The sqlite codes goes to great lengths to avoid data corruption where possible. See also: How To Corrupt Your Database Files http://www.sqlite.org/lockingv3.html#how_to_corrupt ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
