![]() |
#16 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,326
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Quote:
If you haven't checked the option for compressing altogether configuration files and database (whatever wording is in English), then you won't have inside a zip file, but only the KoboReader.sqlite (I guess renamed with a date that you have remove when you copy to Kobo). Last edited by Terisa de morgan; 01-03-2024 at 01:50 PM. |
|
![]() |
![]() |
![]() |
#17 |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 39,075
Karma: 153098470
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Run calibre and open the Kobo Utilities configuration dialog (Customize plugin on the dropdown menu). Click on the second tab and configure the database backup. I've attached an image of my database backup setup.
Your manual database backup can also be used by copying it back to the .kobo directory but I prefer the automated solution. And once again, I recommend a restart before an USB connection. |
![]() |
![]() |
![]() |
#18 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,326
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
|
![]() |
![]() |
![]() |
#19 |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 39,075
Karma: 153098470
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
For me, it is done every time before a USB connect. I haven't seen the database left open after importing books or simply switching between Home, My Books, etc. but I have seen the database left open all too often after reading whether or not I switch to another view. Telnet to my Sage shows either BookReader.sqlite or KoboReader.sqlite have their .sqlite-wal and .sqlite-shm journal and shared memory files present which says the database has not been closed and a USB connection does not seem to close them.
Another poster has mentioned seeing this after importing a large number of files but I haven't seen that on my Sage. I did try to close the database and then chain the USB connect using NickelMenu but the results from that were "interesting". Due to this, I now reboot (using a NickelMenu item) before a USB connect. It may not be needed 80% of the time but faster than restoring the database and cleaning up afterwards. Kobo is aware of the issue and it is supposed to be fixed in the next release but so I've seen nothing released. |
![]() |
![]() |
![]() |
#20 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,326
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Ok, no, I don't do it. Taking into account the number of times I've got to recreate the database in all the years I've got a kobo, I'll take the risk.
|
![]() |
![]() |
![]() |
#21 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 30,301
Karma: 57979022
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
|
![]() |
![]() |
![]() |
#22 | |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 39,075
Karma: 153098470
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
It seems to involve both the BookReader.sqlite and KoboReader.sqlite files since I've seen both with the ancillary files. See the attached image for one example. |
|
![]() |
![]() |
![]() |
#23 |
Diligent dilettante
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 3,439
Karma: 49052774
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra H2O
|
This has been a very helpful thread. I now know that the ONLY way to get a full backup is to configure the settings in Kobo Utlities first. Simply gonig through the menu and selecting "Database>backup database does not work. It does create an sqlite file, the size indicates it most likely IS a copy of the KoboReader.sqlite on the device, but it does not even NAME it, at all. It also does not copy any config files. Had I not started this thread I wouls have gone on virtuously creating "backup" files that were effectively useless.
I'm also grateful for the suggestion to restart the device befoe connecting. I never used to, but given the increasing frequency of database errors I'm having, doing so seems like the course of prudence. I want my Sage to last until the new Carta 1400 400 dpi Sage with 3GHz CPU, voice commands and a 75 gram 10000 mAh battery comes out in August. Of course, it won't have the very latest Adobe RMSDK ![]() |
![]() |
![]() |
![]() |
#24 |
Resident Curmudgeon
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 75,745
Karma: 134321338
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
You don't rename. If the filename does not match the filename on your Kobo, it's not the correct file. The files should be inside the ZIP file with the correct name.
|
![]() |
![]() |
![]() |
#25 | |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 39,075
Karma: 153098470
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
The issue is that the OP was using the Backup device database option under Database in Kobo Utilities menu. You need to supply the name (similar to the OP, I used names similar "KoboReader-2024-01-03" as the filename (the .sqlite was automatically appended) the few times I used that facility). This is not the same as the Device Database Backup configured under the Kobo Utilities configuration being intended more for one shot backups before davidfor tested a database modification. |
|
![]() |
![]() |
![]() |
#26 |
Diligent dilettante
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 3,439
Karma: 49052774
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra H2O
|
Thanks for this extra clarification of the different intended purpose of the two backup options. Now that I know the difference, the bility to save device specific backups is great - previously I only had 1 device to backup anyway
|
![]() |
![]() |
![]() |
Thread Tools | Search this Thread |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
[KOBO] Error communicating with device, CantOpenError: unable to open database file | LSH | Devices | 4 | 06-09-2020 01:33 AM |
Kobo Forma Database Error | csdaley | Devices | 17 | 05-14-2019 10:36 AM |
Error in Kobo Glo: database disk image is malformed | Carpidor | Devices | 2 | 08-07-2015 07:17 AM |
kobo database version unsupported error on MAC 10.6.8 | cloudyweather | Devices | 1 | 09-14-2014 10:14 AM |
Kobo error: database disk image is malformed | RSaunders | Devices | 7 | 07-28-2011 09:52 PM |