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 certain number of records, you
might try a manual binary search for a ROWID that is readable beyond the
failure area, then
   .output mySalvage.txt
   select * from myBadTable where ROWID >= myROWIDgood;
   .output stdout

I realize that neither of these methods is guaranteed to work, and that
you may already be aware of them.

Your backup may turn out to be your best option.

Donald
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to