View Single Post
Old 08-05-2025, 08:07 PM   #6
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 46,654
Karma: 169712392
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Quote:
Originally Posted by Reader4106 View Post
-Does this mean that the entire library folder is to be duplicated?
Yes. In case you can not recover the database due to multiple failures, you should be able to recover most of your books by creating a new library and then using the Add Books from folders and sub-folders option.

Quote:
Originally Posted by Reader4106 View Post
-How can Calibre recovery be started?
With no device connected, click on the Library icon => Library Maintenance => Restore database.

Quote:
Originally Posted by Reader4106 View Post
This error message isn't very long.
With this, along with the necessary background knowledge and suitable tools, could one repair the database "by hand"?
Using calibre's built-in tool is a lot faster and safer than trying to do the task by hand even if you have much experience with SQLite.

Quote:
Originally Posted by Reader4106 View Post
And for a better understanding:
Does the data stored in the respective file (/Volumes/eBooks_LaCie/Calibre_2023_08_12/Author/Book/metadata.opf) contain all the data present in the respective book record? Or only the data stored in the book metadata?
The metadata.opf files in each book folder will allow recovering the database. I am not absolutely certain about some of the odder custom columns but think they are covered.

You can also run the database recovery from a command line which may help in some cases where the GUI is having issues. In a terminal session, the command line below should work but again do a backup of the library before using it. You can also run calibredb alone to see more of it's options.

Code:
/Applications/calibre.app/Contents/MacOS/calibredb restore_database
DNSB is offline   Reply With Quote