Michael Hunley wrote:
What else could cause this "corruption?"
See section 6.0 in http://www.sqlite.org/lockingv3.html.
That article is on SQLite version 3, but the methods for
corrupting a database apply equally well to version 2.
Is there any way to repair the db so the user does not lose his data?
Not really. You can try to recover some of the data by using
the ".dump" command on individual tables. Any tables that do
not contain corruption should come out OK. Version 3 does
a better job of trying to make sense of a corrupt database,
but that doesn't really help users of 2.8. In either version,
the database file does not contain enough redundancy to do any
meaningful recovery once corruption sets in.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
