-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Manoj M wrote: > I am working with a project that requires a SQLite recovery module.
The best thing to do is not corrupt the database in the first place! Do not do any of this http://www.sqlite.org/lockingv3.html#how_to_corrupt In general you cannot recover a database since it would require SQLite to duplicate information in order for it to find a good copy of the data. Sometimes you could get lucky as for example indices do duplicate table columns. > I saw sqlite command-line program is able > to dump my sample corrupted database When the command line program gets a SQLITE_CORRUPT error while dumping a table, it retries the table dump with "ORDER BY rowid DESC" appended. This will get the most recent records until the corruption is hit but you will still lose data. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkecw4ACgkQmOOfHg372QRyKACfWK9yDRwcrKa3cesRDYuww1Ko dQwAn3WLuwJZJSvVXk+eXNhhRufw2K1A =XzXO -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
