Sometimes, the corruption is only or mostly in indexes, in which case it would be possible to get some or most records by trying to dump the entire database with .dump, and use those commands to create a new database:
$ sqlite3 mydata.db ".dump" | sqlite3 new.db The easiest and most reliable way is to use Sqlite Recovery Software <http://www.sqlrecoverytool.com/recover-sqlite-database.html> to fix corruption in SQLite Database. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
