On Aug 28, 2008, at 5:59 PM, Jordan Hayes wrote: > I had a power failure yesterday and an active database of mine is now > trashed. The output of "pragma integrity_check" includes lots of > > rowid NNNN missing from index MyIndexName > > and > > wrong # of entries in index OtherIndexName > > messages. > > Plus this: > > On tree page 4 cell 17: 2nd reference > On tree page 4 cell 17: Child page depth differs > On tree page 4 cell 18: Child page depth differs > > Is there something simple I can do to fix this? It seems like it > would > be useful to have a command that would drop-and-regenerate an index; I > looked in the documentation and couldn't find one.
http://www.sqlite.org/lang_reindex.html > So I dropped them by > hand and rebuilt them and now all those errors go away, but I'm still > left with the last three. > > Am I just out of luck? > Run this command: sqlite3 old.db .dump | sqlite3 new.db D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
