Re: [sqlite] Corrupted SQLITE database recovery

2009-11-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Griggs, Donald wrote: > You may want to try >.dump mytable1 >.dump mytable2 >etc > On individual tables to see if some are salvageable. That is what the underlying dump code does anyway. > For failing tables, if you *can* read a certain n

Re: [sqlite] Corrupted SQLITE database recovery

2009-11-24 Thread Griggs, Donald
Regarding: I have a small corrupted sqlite 3 database. ... Are there any tools for a more detailed analisys? I'm not aware of any, Marko. You may want to try .dump mytable1 .dump mytable2 etc On individual tables to see if some are salvageable. For failing tables, if you *can* read a

[sqlite] Corrupted SQLITE database recovery

2009-11-24 Thread Marko Djukic
I have a small corrupted sqlite 3 database. sqlite> pragma integrity_check; SQL error: database disk image is malformed sqlite> .dump BEGIN TRANSACTION; COMMIT; sqlite> Is there any change of some data recovery? If i take a look with a hex viewer i can still see the CREATE TABLE declarations. I'v