Thread: Preserve reading stats over a factory reset?
View Single Post
Old 02-18-2014, 07:59 PM   #5
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
Quote:
Originally Posted by dmapr View Post
Is this possible? I think I've been bit by the battery bug in 3.0.1 and I would like to see if a factory reset will help, but I'd rather not lose my reading stats if I can help it. So I was wondering if the following procedure should get me there -- does anyone have any experience with this?
  1. Delete all the books from the device
  2. Reboot
  3. Back up the database
  4. Factory reset
  5. Upgrade to the same firmware version I have now (3.1.1)
  6. Restore the database
  7. Reboot
  8. Put the books back
Does it sound reasonable or am I in for an unpleasant surprise?
That should work but it also depends on what you are after.

The reading stats and the book status are stored in different places in the database. The table "content" has a row for each book. This has the reading status (unread, in progress and finished) plus the current position in the book. The table "Event" holds rows for events that happen with the book. This records when you open a book, close a book, finish a book, how many time you turn the page for each book and lot of other things.

If you simply want to keep the reading stats, that should work. But, if you want to keep the reading status status of the books, it won't.

The way I have done this in the past is to backup the complete user partition, do the factory reset and upgrade and the testing I wanted to do. Then I restored the complete user partition.

The alternative is using calibre and my Kobo Utilities plugin. This can store the reading status for all the books that are on the device and in the library. After the factory reset and restoring the books, it can set their reading status.

There is an added complication for books kepubs from the Kobo server. I'm not sure what state these will be in after your method. There is a good chance they will be listed in the library but will give errors when you open them.
davidfor is offline   Reply With Quote