-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 08/11/2010 10:28 PM, Kirk Clemons wrote: > I would like to be able to tell SQLite that if line 2 is bad just skip to > line 3 and so on until the database has been parsed all the through > maximizing the amount of data I retain.
It would require detailed knowledge of the corruption and what it affected. For example a very slow brute force algorithm would be to ask for all rows with a rowid >=0, add one to the highest returned and do another select greater than that. Perhaps repeat in reverse order. You are however far better off preventing the corruption in the first place, ensuring a good backup and recovery strategy etc. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxkaF0ACgkQmOOfHg372QRDWACcDUlXb5vpI00VvX5f0tbq548/ L4cAoMEbCws5s57qi+vj8Dz9sLKVc7H1 =FmQE -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
