MobileRead Forums - View Single Post - Aura ONE What is the best way to restore Kobo annotations from a backup?

pl8o · 07-02-2019, 06:09 PM

My Kobo (Aura ONE, 4.15.12920) has thrown out its annotations again. This time, it has thrown out *all* the annotations for *one* sideloaded .epub book.

I have a full SD card backup from a few days before, but I haven’t managed to restore successfully.

---

About a week ago, I noticed that my Kobo had thrown out about a days worth of annotations in this same sideloaded book. In addition, when opening the book, progress was not being saved properly.

Around this point, I made a backup (from now on referred to as "second-to-last backup"). Unfortunately, I don’t recall for sure whether it was made before or after I first noticed the issue.

But it was only a day’s worth of annotations, so I didn’t worry too much.

A few days ago, though, I noticed at around the same time that:

2. *All* my annotations were gone from that book.
1. When I put my device to sleep, it showed the cover for the wrong book (it was showing the cover for a different sideloaded epub).

Around *this* point, I made a backup (from now on referred to as "latest backup"). Unfortunately, I don’t recall for sure whether it was made before or after I first noticed the issue

---

I have been careful not to turn on Wifi, or sync, since then, since I’ve had nightmares with sync conflicts in the past when restoring from a backup.

What I have discovered so far:

- My Kobo has indeed deleted all annotations for the book from the Bookmark table of KoboReader.sqlite.
- When I load them back on (full SD restore from most recent backup) they just disappear again.
- Most recent backup has no annotations in Digital Editions file for that book, even though annotations are in SQLite database.
- Second-to-last backup has annotations in a Digital Editions file as well as database.
- Comparing the most recent annotation from second-to-last backup with the same annotation from latest backup, I noticed that the ContentID field is blank in most recent backup. Everything else, for annotations that are in both backups (id, etc) seem to be identical.
- When I insert a ContentID matching older backup, Kobo still throws them all out.

Maybe the Digital Editions folder is somehow pulling rank over data in the Bookmark table of the SQLite DB?

Does anyone have tips on how to get Kobo to accept my backed up annotations for the book, rather than deleting them?

Thanks!

07-02-2019, 06:09 PM	#1
pl8o Junior Member Posts: 8 Karma: 10 Join Date: Nov 2018 Device: Kobo Sage (prev, Nook, Nook Simple Touch, Kindle 7, Kobo Touch, KA1	What is the best way to restore Kobo annotations from a backup? My Kobo (Aura ONE, 4.15.12920) has thrown out its annotations again. This time, it has thrown out all the annotations for one sideloaded .epub book. I have a full SD card backup from a few days before, but I haven’t managed to restore successfully. --- About a week ago, I noticed that my Kobo had thrown out about a days worth of annotations in this same sideloaded book. In addition, when opening the book, progress was not being saved properly. Around this point, I made a backup (from now on referred to as "second-to-last backup"). Unfortunately, I don’t recall for sure whether it was made before or after I first noticed the issue. But it was only a day’s worth of annotations, so I didn’t worry too much. A few days ago, though, I noticed at around the same time that: 2. All my annotations were gone from that book. 1. When I put my device to sleep, it showed the cover for the wrong book (it was showing the cover for a different sideloaded epub). Around this point, I made a backup (from now on referred to as "latest backup"). Unfortunately, I don’t recall for sure whether it was made before or after I first noticed the issue --- I have been careful not to turn on Wifi, or sync, since then, since I’ve had nightmares with sync conflicts in the past when restoring from a backup. What I have discovered so far: - My Kobo has indeed deleted all annotations for the book from the Bookmark table of KoboReader.sqlite. - When I load them back on (full SD restore from most recent backup) they just disappear again. - Most recent backup has no annotations in Digital Editions file for that book, even though annotations are in SQLite database. - Second-to-last backup has annotations in a Digital Editions file as well as database. - Comparing the most recent annotation from second-to-last backup with the same annotation from latest backup, I noticed that the ContentID field is blank in most recent backup. Everything else, for annotations that are in both backups (id, etc) seem to be identical. - When I insert a ContentID matching older backup, Kobo still throws them all out. Maybe the Digital Editions folder is somehow pulling rank over data in the Bookmark table of the SQLite DB? Does anyone have tips on how to get Kobo to accept my backed up annotations for the book, rather than deleting them? Thanks!