-----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 number of records, you
> might try a manual binary search for a ROWID that is readable beyond the
> failure area, then

When the dump code gets an error in dumping a table it then retries the dump
with the table contents sorted highest rowid first.

See also:

  http://www.sqlite.org/src/tktview?name=ee19e690ec
  http://www.sqlite.org/src/tktview?name=2466653295

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAksMO5cACgkQmOOfHg372QSchgCgvY6KhPxr3gAy5qRa0JsnnEap
vaAAnRstCxYxCiZZK8ZrondTkY7uZ2NJ
=Q12K
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to