SQLite Forum

Duplicated rows (and missing rows) when SELECTing with ORDER BY
Login
Assuming the database file is corrupted, as seems likely (see the answer by David Raymond), you may be able to recover it using the `.recover` command of the sqlite shell:

    sqlite3 original.db .recover | sqlite3 new.db

Run `.help recover` in the interactive shell to see some possibly useful options.

But after any database corruption, you should view the recovered data with some skepticism.