Backing up database

Tawn · 11-11-2023, 09:57 PM

I don't use Calibre and would like to do a backup of the database file. Can I simply copy KoboReader.sqlite (and restore it if necessary) ?

My Libra2 was acting weird and it reminded me that I'd been intending to inquire about this. Tried to highlight a paragraph & it somehow highlighted everything from there to the end of the chapter -many pages away- then froze when I tried to tap it to remove it. I didn't think it was even possible to highlight across many pages like that! Had to reboot then clear it from the annotations list (where it displayed as a blank entry).

Aleron Ives · 11-11-2023, 10:46 PM

That highlighting behaviour is caused by bad formatting in the book. I've had it happen in one of my books, too.

You can indeed back up the sqlite file and restore it later. You'll want NickelMenu installed so you can reboot the device immediately after replacing the database file and ejecting, to ensure you don't get any weirdness with the restored backup not matching whatever database state your Libra has in memory at the time you do the swap.

Quoth · 11-12-2023, 06:54 AM

Or just reboot after copying back an earlier database.

JSWolf · 11-12-2023, 07:03 AM

Quote:

Originally Posted by Tawn

I don't use Calibre and would like to do a backup of the database file. Can I simply copy KoboReader.sqlite (and restore it if necessary) ?

My Libra2 was acting weird and it reminded me that I'd been intending to inquire about this. Tried to highlight a paragraph & it somehow highlighted everything from there to the end of the chapter -many pages away- then froze when I tried to tap it to remove it. I didn't think it was even possible to highlight across many pages like that! Had to reboot then clear it from the annotations list (where it displayed as a blank entry).

It's actually easier to use calibre and Kobo Utilities to backup your database and config file.

Tawn · 11-12-2023, 08:30 PM

Quote:

Originally Posted by Aleron Ives

That highlighting behaviour is caused by bad formatting in the book. I've had it happen in one of my books, too.

Good to know.

Quote:

Originally Posted by Aleron Ives

You can indeed back up the sqlite file and restore it later. You'll want NickelMenu installed so you can reboot the device immediately after replacing the database file and ejecting, to ensure you don't get any weirdness with the restored backup not matching whatever database state your Libra has in memory at the time you do the swap.

Thanks. I already had the reboot option on my Nickle Menu.

11-11-2023, 09:57 PM	#1
Tawn Connoisseur Posts: 75 Karma: 10 Join Date: Mar 2022 Device: kobo Libra 2	Backing up database I don't use Calibre and would like to do a backup of the database file. Can I simply copy KoboReader.sqlite (and restore it if necessary) ? My Libra2 was acting weird and it reminded me that I'd been intending to inquire about this. Tried to highlight a paragraph & it somehow highlighted everything from there to the end of the chapter -many pages away- then froze when I tried to tap it to remove it. I didn't think it was even possible to highlight across many pages like that! Had to reboot then clear it from the annotations list (where it displayed as a blank entry).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Failed: Backing up Kobo device database" - brand new Sage	jcf	Devices	10	01-12-2022 10:36 AM
Backing up Kobo device database never stops	ServerManDann	Devices	2	10-01-2021 01:22 AM
Backing up Stanza	midlifec	Apple Devices	1	10-02-2012 03:08 AM
Backing everything up	ardeur	Library Management	1	03-10-2012 03:59 AM
Calibre Database cp Kindle Database	mitch13	Library Management	1	05-22-2011 07:33 PM

11-11-2023, 10:46 PM	#2
Aleron Ives Wizard Posts: 1,689 Karma: 16307824 Join Date: Sep 2022 Device: Kobo Libra 2	That highlighting behaviour is caused by bad formatting in the book. I've had it happen in one of my books, too. You can indeed back up the sqlite file and restore it later. You'll want NickelMenu installed so you can reboot the device immediately after replacing the database file and ejecting, to ensure you don't get any weirdness with the restored backup not matching whatever database state your Libra has in memory at the time you do the swap.

11-12-2023, 06:54 AM	#3
Quoth Still reading Posts: 14,037 Karma: 105092227 Join Date: Jun 2017 Location: Ireland Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper	Or just reboot after copying back an earlier database.

Advert

Advert