restore database

franklekens · 08-06-2023, 10:22 AM

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?

Quoth · 08-06-2023, 11:33 AM

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.

John F · 08-06-2023, 12:51 PM

Do you need to reboot also? I seem to recall about the db being cached?

Aleron Ives · 08-06-2023, 03:44 PM

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.

Quoth · 08-06-2023, 05:41 PM

Quote:

Originally Posted by Aleron Ives

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.

Yes, that's needed.

JSWolf · 08-08-2023, 05:27 PM

When I replaced my database on my Libra 2 with the database from my Aura H2O, I rebooted right after and it worked perfectly.

franklekens · 10-04-2023, 09:32 AM

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.

franklekens · 10-04-2023, 10:18 AM

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.)

franklekens · 10-04-2023, 10:32 AM

Except of course after a few disconnects it starts all over again...

DNSB · 10-04-2023, 12:25 PM

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.

JSWolf · 10-04-2023, 01:53 PM

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.

08-06-2023, 10:22 AM	#1
franklekens Addict Posts: 392 Karma: 3421956 Join Date: Sep 2009 Device: Kobo Forma, Sage, Elipsa, 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?

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

08-06-2023, 11:33 AM	#2
Quoth the rook, bossing Never. Posts: 11,173 Karma: 85874891 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.

08-06-2023, 12:51 PM	#3
John F Grand Sorcerer Posts: 7,174 Karma: 63764653 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
Aleron Ives Wizard Posts: 1,026 Karma: 11500112 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-08-2023, 05:27 PM	#6
JSWolf Resident Curmudgeon Posts: 74,044 Karma: 129333562 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
franklekens Addict Posts: 392 Karma: 3421956 Join Date: Sep 2009 Device: Kobo Forma, Sage, Elipsa, 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
franklekens Addict Posts: 392 Karma: 3421956 Join Date: Sep 2009 Device: Kobo Forma, Sage, Elipsa, 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
franklekens Addict Posts: 392 Karma: 3421956 Join Date: Sep 2009 Device: Kobo Forma, Sage, Elipsa, 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
DNSB Bibliophagist Posts: 35,513 Karma: 145557716 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Forma, Clara HD, 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
JSWolf Resident Curmudgeon Posts: 74,044 Karma: 129333562 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.

Advert

Advert