Database corruption: fix?

richorlin · 05-21-2025, 03:31 PM

Somehow both the original and my external backup metadata files got corrupted and I can't open Calibre from original directory or the backup.
When I try, I get the error that there is no Calibre library.
Is there a workaround to force Calibre to open a library an reindex?
The only option I can think of is to create a new library and import all the books. That's 20K of books. Then they will not be in any date order, but all one date.
Than you for any help.

ownedbycats · 05-21-2025, 03:47 PM

Try Library > Library Maintenace >Restore Database. If not work, re-importing to new library. Make sure to add custom columns back first.

richorlin · 05-21-2025, 04:02 PM

Thanks, but I can’t open the library. It says there is no library in that folder, although there are 20k books there and the index files.

DNSB · 05-21-2025, 04:25 PM

You could try running calibredb from the command line with calibre closed. See restore_database for some help. If you don't specify the library path, it will default to the one stored in your settings.

Code:

calibredb restore_database -r --library-path=<path to your library>

You might want to first try to create a new library. Switch to the new library and Add books from folders and subfolders pointing to your old library as the source.

richorlin · 05-21-2025, 04:45 PM

I’ll try your suggestion for using the command line. From past experience, adding the books doesn’t preserve the original date. So all ten years of books have the same date.

richorlin · 05-21-2025, 04:51 PM

How do I run calibredb from terminal (macos). Comes back command not found.

BetterRed · 05-21-2025, 06:01 PM

First para ==>> calibre User Manual: Command Line Interface

BR

richorlin · 05-21-2025, 10:44 PM

Ran the terminal command and 50 mins later Calibre was up and running. Thanks all. A great community of users!

05-21-2025, 03:31 PM	#1
richorlin Enthusiast Posts: 31 Karma: 10 Join Date: Oct 2007 Device: Kindle	Database corruption: fix? Somehow both the original and my external backup metadata files got corrupted and I can't open Calibre from original directory or the backup. When I try, I get the error that there is no Calibre library. Is there a workaround to force Calibre to open a library an reindex? The only option I can think of is to create a new library and import all the books. That's 20K of books. Then they will not be in any date order, but all one date. Than you for any help.

05-21-2025, 04:25 PM	#4
DNSB Bibliophagist Posts: 45,051 Karma: 168808721 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	You could try running calibredb from the command line with calibre closed. See restore_database for some help. If you don't specify the library path, it will default to the one stored in your settings. Code: calibredb restore_database -r --library-path=<path to your library> You might want to first try to create a new library. Switch to the new library and Add books from folders and subfolders pointing to your old library as the source.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clara HD Is occasional database corruption to be expected?	Desertway	Kobo Reader	25	05-23-2022 07:53 PM
Database Corruption / FW 3.5.0	PeterT	Kobo Reader	7	08-26-2014 04:10 PM
Database Corruption during Installation	aronan	Calibre	3	09-10-2010 01:17 AM
Problems after database corruption	ficbot	Calibre	2	09-25-2009 02:11 PM
Database Corruption!!	Alexander Turcic	Announcements	0	07-22-2003 10:08 AM

05-21-2025, 03:47 PM	#2
ownedbycats Custom User Title Posts: 10,726 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Try Library > Library Maintenace >Restore Database. If not work, re-importing to new library. Make sure to add custom columns back first.

05-21-2025, 04:02 PM	#3
richorlin Enthusiast Posts: 31 Karma: 10 Join Date: Oct 2007 Device: Kindle	Thanks, but I can’t open the library. It says there is no library in that folder, although there are 20k books there and the index files.

05-21-2025, 04:45 PM	#5
richorlin Enthusiast Posts: 31 Karma: 10 Join Date: Oct 2007 Device: Kindle	I’ll try your suggestion for using the command line. From past experience, adding the books doesn’t preserve the original date. So all ten years of books have the same date.

05-21-2025, 04:51 PM	#6
richorlin Enthusiast Posts: 31 Karma: 10 Join Date: Oct 2007 Device: Kindle	How do I run calibredb from terminal (macos). Comes back command not found.

05-21-2025, 06:01 PM	#7
BetterRed null operator (he/him) Posts: 21,644 Karma: 29710510 Join Date: Mar 2012 Location: Sydney Australia Device: none	First para ==>> calibre User Manual: Command Line Interface BR

05-21-2025, 10:44 PM	#8
richorlin Enthusiast Posts: 31 Karma: 10 Join Date: Oct 2007 Device: Kindle	Ran the terminal command and 50 mins later Calibre was up and running. Thanks all. A great community of users!

Advert

Advert