How to extract annotations from KoboReader.sqlite

Lucas Malor · 04-15-2023, 08:47 AM

Well, I have done a stupid thing: I disconnected from Kobo account. All my annotations are lost.

I have a copy of the old db. Is there a way to extract the annotations and put them again in the new db?

PS: I have calibre 6 and KoboUtilities plugin.

qkqw · 04-15-2023, 09:06 AM

Putting them back might be difficult, as the IDs of your books might have changed. But extracting them from your old Sqlite file should be quite easy. You could adapt this script to get all your annotations:

https://www.mobileread.com/forums/sh...d.php?t=349637

Lucas Malor · 04-15-2023, 09:14 AM

So have I to temporarily replace the new db with the old db on the Kobo itself?

If so, I think I can sync the annotations with Calibre. My only doubt is: is it safe to replace the database with an old copy? I ask this because I also upgraded the firmware in the meanwhile...

04-15-2023, 08:47 AM	#1
Lucas Malor Pain in the arse Posts: 758 Karma: 77856 Join Date: Apr 2013 Device: Kobo Aura One, Kindle 4	How to extract annotations from KoboReader.sqlite Well, I have done a stupid thing: I disconnected from Kobo account. All my annotations are lost. I have a copy of the old db. Is there a way to extract the annotations and put them again in the new db? PS: I have calibre 6 and KoboUtilities plugin.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exporting list of authors from KoboReader.sqlite	Semwize	Kobo Reader	4	06-14-2021 10:57 AM
KoboReader.sqlite: export and reimport annotations or edit	gabryele	Kobo Reader	1	05-25-2017 12:15 AM
Aura KoboReader.Sqlite help (stats lost)	Skyfall	Kobo Developer's Corner	6	03-29-2015 05:21 AM
Glo koboreader.sqlite File	LaLaLia	Kobo Reader	3	10-05-2014 08:05 PM
Koboreader.sqlite gundged	maxwelledison	Kobo Reader	21	01-12-2011 08:24 AM

04-15-2023, 09:06 AM	#2
qkqw Connoisseur Posts: 63 Karma: 143000 Join Date: Apr 2022 Device: Kobo Libra 2	Putting them back might be difficult, as the IDs of your books might have changed. But extracting them from your old Sqlite file should be quite easy. You could adapt this script to get all your annotations: https://www.mobileread.com/forums/sh...d.php?t=349637

04-15-2023, 09:14 AM	#3
Lucas Malor Pain in the arse Posts: 758 Karma: 77856 Join Date: Apr 2013 Device: Kobo Aura One, Kindle 4	So have I to temporarily replace the new db with the old db on the Kobo itself? If so, I think I can sync the annotations with Calibre. My only doubt is: is it safe to replace the database with an old copy? I ask this because I also upgraded the firmware in the meanwhile...