-----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