08-06-2023, 10:22 AM | #1 |
Addict
Posts: 392
Karma: 3421956
Join Date: Sep 2009
Device: various Kobo's, Onyx Note2, Pocketbook 360, Kindle Keyboard
|
restore database
I see issues of a corrupt database mentioned here, and the Kobo Utilities plugin for calibre always makes a backup of the database when I hook the device up to the computer. But what I cannot find here are instruction on how to restore such a backed up database to the device. Nor can I find an option to do that in the Kobo Utilities plugin. What am I overlooking?
|
08-06-2023, 11:33 AM | #2 |
the rook, bossing Never.
Posts: 12,280
Karma: 89822819
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
|
You copy it back. Obviously back up existing one with current date in naem and give the prior back up the existing name. My database backups are <devicename><yyyymmdd> in a per owner subdirectory, with leading zeros on month and day.
|
Advert | |
|
08-06-2023, 12:51 PM | #3 |
Grand Sorcerer
Posts: 7,479
Karma: 67500159
Join Date: Feb 2009
Device: Kobo Glo HD
|
Do you need to reboot also? I seem to recall about the db being cached?
|
08-06-2023, 03:44 PM | #4 |
Wizard
Posts: 1,391
Karma: 16297052
Join Date: Sep 2022
Device: Kobo Libra 2
|
The Kobo doesn't expect the database to get completely replaced during normal operation, so rebooting as soon as you disconnect from USB would surely be a wise move.
|
08-06-2023, 05:41 PM | #5 |
the rook, bossing Never.
Posts: 12,280
Karma: 89822819
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
|
|
Advert | |
|
08-08-2023, 05:27 PM | #6 |
Resident Curmudgeon
Posts: 76,104
Karma: 134368292
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
When I replaced my database on my Libra 2 with the database from my Aura H2O, I rebooted right after and it worked perfectly.
|
10-04-2023, 09:32 AM | #7 |
Addict
Posts: 392
Karma: 3421956
Join Date: Sep 2009
Device: various Kobo's, Onyx Note2, Pocketbook 360, Kindle Keyboard
|
Could someone enlighten me, because "copy back the database" doesn't get me very far.
On my ereader, in the root directory there are a lot of book files plus these two: metadata.calibre drieinfo.calibre Is one of these the database file? In the directory with database backups, I have files like this: KoboReader-KoboSage-N778235036681-20231004-143849.zip This one contains these files (plus a few adobe-digital.editions subfolder): version KoboReader.sqlite Kobo ereader.conf Bookreader.sqlite affiliate.conf" Do I have to rename one of these files to one of the first mentioned files, or what? Incidentally, it's happened AGAIN, one of those factory resets. But I've noticed something strange. I initially thought every time the 3000+ imported books on it were "lost" and I had to reimport them (in batches of about 500 at most to be sure). But I noticed that I don't actually have to. What happens is this: i connect the device to the computer. Calibre recognizes it. It looks as some of the books have already been imported. I disconnect. After disconnecting (without my manually sideloading anything, note!) the device starts to "import items". Apparently now it spontaneously starts to reimport another batch of the book files -- which were on the device to begin with. It just didn't manage to reimport them. But every time I connect and disconnect from the computer, it spontaneously reimports another batch of the books that were there all along. It even seems to reimport the shelving with it. Of course I *have* lost all bookmarks & notes & such. The device simply is hardly usable to make notes or highlights anymore. They'll get lost. (Unless I plug into the Kobo environment &c of course. Kobo Plus books data are saved on the server.) What could this mean? They've done something in the firmware to Or are data about imported books actually stored on the Kobo server as well (invisibly, as nothing of that is visible on the website, AFAIK)? Oh, hold up... this is the behaviour it *did* display. Up until it got about 2300 book on the device (according to the home screen count). But on the last connect & disconnect, it went back to the configuration screen again. Back to square one. What a mess. |
10-04-2023, 10:18 AM | #8 |
Addict
Posts: 392
Karma: 3421956
Join Date: Sep 2009
Device: various Kobo's, Onyx Note2, Pocketbook 360, Kindle Keyboard
|
Still, at the second try, after a few connects/disconnects, the device's contents do seem to have reconstituted them more or less as they were before the forced factory reset.
Still a major annoyance, but slightly less aggravating than when I was first confronted with it. (Slightly.) |
10-04-2023, 10:32 AM | #9 |
Addict
Posts: 392
Karma: 3421956
Join Date: Sep 2009
Device: various Kobo's, Onyx Note2, Pocketbook 360, Kindle Keyboard
|
Except of course after a few disconnects it starts all over again...
|
10-04-2023, 12:25 PM | #10 |
Bibliophagist
Posts: 39,964
Karma: 154914010
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
The two files you mentioned in the root of the exposed partition are calibre files and nothing to do with the Kobo database files. To restore a corrupted Kobo database, you would copy the KoboReader.sqlite and Bookreader.sqlite files into the .kobo directory. Since the Kobo ereader.conf is very likely to get reset as well, you would copy that file into the .kobo/Kobo directory. You would also loose the screensaver directory inside the .kobo directory.
I would again recommend doing a reboot before connecting to your computer. There have been several message threads which included the NickelMenu entries to do that. |
10-04-2023, 01:53 PM | #11 |
Resident Curmudgeon
Posts: 76,104
Karma: 134368292
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
If you are not going to the home screen before connecting to the computer, I suggest you do so. I go to the home screen before connecting to the computer and it works without having any database corruption. No need to reboot.
Your mileage may vary. |
05-30-2024, 10:40 PM | #12 |
Member
Posts: 13
Karma: 10
Join Date: May 2024
Location: Atlanta
Device: Kobo Libra Colour
|
I'm having a hard time telling if this thread would help me. I had a similar issue (even though I'm always on homescreen before connecting to PC etc) so I used a backup to get my libra colour looking normal again. What I don't get is that it lost my reading progress & notes/highlights. How do I get that back? Like what is a reliable way to back up notes/highlights?
(I set up up Calibre as I saw mentioned online to back this up but the columns it has for like reading progress has been stuck forever at 68% even though I've read past that. Nothing ever shows in the annotations column even though I've made highlights) |
05-31-2024, 12:03 AM | #13 |
Bibliophagist
Posts: 39,964
Karma: 154914010
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
If you install the Kobo Utilities plugin, you can configure an automatic backup on the second page of it's configuration.
As mentioned before, I also use a NickelMenu item to reboot my Sage before I connect it to my computer. |
05-31-2024, 08:32 AM | #14 |
Member
Posts: 13
Karma: 10
Join Date: May 2024
Location: Atlanta
Device: Kobo Libra Colour
|
I've always had it set up to back up every time connected on that 2nd page. It just doesn't work so I don't know if I'm missing something. (I'm so new to Kobo and barely figuring the basics out so not comfortable diving into whatever NickelMenu is yet. I've made note of it though. Seems so odd one would have to reboot a device before connecting every time. My kindles were always so easy to use. Simpler system than Kobo though of course.)
https://photos.google.com/photo/AF1Q...P0OGen3m_bvEvo Last edited by Kayaditi; 05-31-2024 at 08:34 AM. |
05-31-2024, 01:43 PM | #15 | |
Bibliophagist
Posts: 39,964
Karma: 154914010
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
For me, the reboot was not needed until the 4.38 firmware revision. It does not appear to be an issue in 4.39 on my Libra Colour. I've attached an image of the configuration I use with Windows for my database backups (replace the file path with your preference). |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restore Database at 100% | Arro | Library Management | 4 | 10-31-2016 03:00 PM |
Aura Restore the database | Ksquared | Kobo Reader | 2 | 09-17-2016 08:04 AM |
Restore Database? | BookJunkieLI | Library Management | 6 | 08-15-2014 06:10 PM |
Restore Database? | BeeTee-Ess | Calibre | 2 | 10-12-2012 07:40 AM |
restore database help | mabee | Calibre | 13 | 01-11-2011 02:16 PM |