Thread: How to manually fix a (probably) corrupted database?
View Single Post
Old 05-08-2013, 06:07 AM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
It depends on the problem. I have fixed mine a couple of times, but in those cases a couple of indexes were corrupt. Forcing a rebuild was enough.

Every other time, it has been inaccessible pages in the database. I haven't found a method to fix this. But, I haven't tried that hard. The logout has fixed things most times. And I have no hassle with an occasional factory reset, the other times.

I also backup the database when I am doing something that might be dangerous to the database. Then I can simply restore it.

If you want to see what the problem is, you need to run the command "PRAGMA integrity_check" against the database. If you have an SQLite browser or other SQLite tool, that should be able to run it.
davidfor is offline   Reply With Quote