On Tue, Nov 20, 2012 at 1:51 PM, sqdev123 <sqdev...@gmail.com> wrote:
> Current status:
> I decrypted the malformed database by manipulating the
> SQLiteConnection.Open
> method in a way that it does not run any SQLiteCommands, as they call
> Prepare which fails because of the corrupt schema.
> Then, I called SQLiteConnection.ChangePassword("") on the instance returned
> by SQLiteConnection.Open.
> The encryption was actually removed, but the schema was still corrupt.
>
> So I used SQLite-CLI to create a dump (i.e. an SQL script containing the
> schema and the data).
> Then, I used that script to create a new database.
> That seemed to work - the resulting database does not have a corrupt schema
> and data is still ok. Some of the data might be missing though - I couln't
> check that yet.
>
Please send me an example of your corrupt database.
>
> One important question remains: What causes the database schema to become
> corrupt?
> I already had several corrupt databases.
>
>
>
>
> --
> View this message in context:
> http://sqlite.1065341.n5.nabble.com/malformed-database-schema-tp65610p65622.html
> Sent from the SQLite mailing list archive at Nabble.com.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
