Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 08-25-2013, 05:53 AM   #1
mjost
Member
mjost began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Jan 2013
Location: Munich
Device: Kobo Glo
How to transfer bookmarks and comments to a new SQLite database

Hello,

in my understanding all the bookmarks and comments I created on my Kobo Glo are stored in the SQlite DB (.kobo/KoboReader.sqlite) on the device.
Some time ago, a firmware update of my Glo made it hang, so I had to reset it.
Now the DB got replaced by a fresh copy. No problem to get my books back in (from Calibre), but now all the bookmarks and comments are gone ;-(

I have a backup-copy of the DB file on the HD of my computer. But just replacing the DB on the device, by the one from the HD doesn't work.
(Version differences ?)

Has anybody found a way to get the information over ?

Regards

Martin

P.S.:
I'll post my finding so far on a reply in this thread and I try to add more stuff as I find it.
Nevertheless I still appreciate a complete solution form somebody... ;-)
mjost is offline   Reply With Quote
Old 08-25-2013, 07:49 AM   #2
paola
Wizard
paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.paola ought to be getting tired of karma fortunes by now.
 
paola's Avatar
 
Posts: 2,824
Karma: 5843878
Join Date: Oct 2010
Location: UK
Device: Pocketbook Pro 903, (beloved Pocketbook 360 RIP), Kobo Mini, Kobo Aura
Quote:
Originally Posted by mjost View Post
I have a backup-copy of the DB file on the HD of my computer. But just replacing the DB on the device, by the one from the HD doesn't work.
(Version differences ?)
actually, this is what I do when there are problems, delete the sqlite file on the device and replace it with the back up copy - I also delete the two calibre files for good measure. I do this with Calibre NOT running, then after the replacement I open calibre, then disconnect. So far it has been working fine for me.
paola is offline   Reply With Quote
Advert
Old 08-25-2013, 09:00 AM   #3
mjost
Member
mjost began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Jan 2013
Location: Munich
Device: Kobo Glo
First round of notes....

Hello,

as announced my findings so far.
To look into one of the DBs, I'm using SQLite Manager for Firefox:
https://code.google.com/p/sqlite-manager/

Schemaspy can be used to get an overview:
http://schemaspy.sourceforge.net/
There is also an schema for the Kobo DB here:
http://kobodb-schema.sourceforge.net/index.html
But this is version 52, while my DB claims to be 101 - quite a gap.

The "Bookmark" table seems to contain the notes:
column "text": Marked text
column "Annotation": The note added ot the bookarm/marked text

Regards

Martin
mjost is offline   Reply With Quote
Old 08-26-2013, 03:32 AM   #4
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,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
The simple answer is to export the contents of the Bookmark table in the old database. Then load these into the table in the new database.

The above should work as long as:

- The books are in the same directory
- The names of the books did not change
- There are no files in "Digital Editions\Annotations". If there are, delete these first.

If you have purchased some kepubs and made annotations, these should have been synced to the Kobo server and back. I would recommend that you not include these when you do the export or load. The rows you want will have "VolumeID like '%file:///'".
davidfor is offline   Reply With Quote
Old 08-31-2013, 03:07 AM   #5
mjost
Member
mjost began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Jan 2013
Location: Munich
Device: Kobo Glo
Hello,

I tried (again) to just restore the database file.
I had the bookmarks in the single book bought from the Kobo store back. But this is probably due to the sync.
In the other books, this didn't work.

I'll try the recommendation by davidfor and let you know.

Thanks !

Martin
mjost is offline   Reply With Quote
Advert
Reply

Tags
bookmarks, database, glo, kobo, sqlite

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Kobo sqlite database darkadept Kobo Reader 38 09-08-2013 08:12 PM
Sqlite database replacement instructions pholy Kobo Reader 62 10-11-2012 09:19 AM
Sqlite database clean up mapline Kobo Reader 2 08-01-2012 11:12 PM
Kobo Database Browser - SQLite JBlyth Kobo Reader 2 06-06-2010 09:27 PM
How to transfer bookmarks? Roamor Sony Reader 2 12-13-2008 09:32 AM


All times are GMT -4. The time now is 08:46 AM.


MobileRead.com is a privately owned, operated and funded community.