Paul Smith wrote:
If I do pragma integrity_check on a database I get:
*** in database main ***
On page 8 cell 0: invalid page number 1581
SQL error: database disk image is malformed
---
Is there any way to "fix" this (even if some data is lost), or does it
just need throwing away and restoring from backup?
Use the command-line tool as follows:
sqlite DATABASENAME .dump >recover.sql
You may get some of your data back that way. Or maybe not.
Depends on how lucky you are.
(Any ideas what could have caused these types of errors?)
Read section 6.0 "How To Corrupt Your Database Files" in
http://www.sqlite.org/lockingv3.html
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
