![]() |
#1 |
Member
![]() Posts: 13
Karma: 10
Join Date: Nov 2023
Device: Calibre
|
Restore custom columns
I successfully restored a library via
Library > Library Maintenance > Restore Database but I stil can't see the custom cloumns. Any recommendations to restore the custom columns would be highly appreciated. ![]() |
![]() |
![]() |
![]() |
#2 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 31,025
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Did you destroy metadata_db_prefs_backup.json?
That was YOUR structure backup and should have been used as part of the restore |
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Member
![]() Posts: 13
Karma: 10
Join Date: Nov 2023
Device: Calibre
|
No, i still have it, but I am not sure how I can use it.
|
![]() |
![]() |
![]() |
#4 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 31,025
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
It should have been used if it was in the normal place when you ran restore.
The issue now, is the metadata.opf backup file has been overwritten ![]() Your only chance is if you Polished the books and embedded the metadata BEFORE your corruption. In that case, you can use the Metadata editor and fetch the books copy of the metadata In bulk mode. Do only for books that you KNOW are correct. If the book is stale or wrong, that can ruin the better entry tick Set Metadata from book files |
![]() |
![]() |
![]() |
#5 | |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 21,710
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
Check Preferences->Add your own columns. BR |
|
![]() |
![]() |
Advert | |
|
![]() |
#6 |
Member
![]() Posts: 13
Karma: 10
Join Date: Nov 2023
Device: Calibre
|
|
![]() |
![]() |
![]() |
#7 | |
Member
![]() Posts: 13
Karma: 10
Join Date: Nov 2023
Device: Calibre
|
Quote:
Library > Library Maintenance > Restore Database Question Where the metadata.opf file is located? When I performed the respore, I had only 2 files in the library (1) metadata_db_prefs_backup.json and (2) metadata.db and after the restore, I found 3 files (1) metadata_db_prefs_backup.json, (2) metadata.db (3) metadata_pre_restore.db I am running Calibre on an iMac, and I have TimeMachine running all the time. (1) If metadata.opf is located somewhere other than the library folder, I will try to restore a previous verison of it. The only other folder associated with Calibre on teh operating system that I am aware of is the configuration folder (shown in the screenshot). In that folder, I could not find a metadata.opf https://ibb.co/SKPg6br (2) Question: I understand that Calibre is not designed for simultanuous access (therefore it's not recommneded to be hosted on a cloud service or NAS. Does that also apply to AppleTime Machine? i.e could Apply TimeMachine reuin the database? When I looked at the metadata editor, I could not find the option "Set Metadata from book files" . Question: I would appreciate that you point me to it to give it a try. |
|
![]() |
![]() |
![]() |
#8 | |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 31,025
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
there is a metadata.opf is in each books folder (and cover.jpg). Those are the backup for that book metadata as shown in Calibre Anything that tampers with the Library folder can corrupt. Only Calibre should make changes. The DB is the link between the entry and the files. Delays can allow a cart before horse condition, thus the rule of NOT on a Network storage. BTW your screenshot is NOT of Calibre Library (the typical folder where books are) |
|
![]() |
![]() |
![]() |
#9 |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 21,710
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
|
![]() |
![]() |
![]() |
#10 | |
Member
![]() Posts: 13
Karma: 10
Join Date: Nov 2023
Device: Calibre
|
Quote:
You are correct, the screenshot I sent is not from Calibre, I accessed it through Preferences > Miscellaneous > Open calibre cofiguration folder Now, I have 2 questions: 1- My undestanding is that given that I have already performed the restore, the metadata.opf for each book has been overwritten and the custom columns settings have been lost. However, if I have a backup of the library which includes the metadata.opf files before restoration, I should be able to restore the custom columns through the metadata editor. The issue is that I could not find the option "Set Metadata from book files" . Question: I would appreciate that you point me to that option. 2- Does backuping up the library using Time machine considered tampering with the Library folder? If no, that is goog. If, yes, what is the best practice to have a disaster recovery plan? |
|
![]() |
![]() |
![]() |
#11 |
Member
![]() Posts: 13
Karma: 10
Join Date: Nov 2023
Device: Calibre
|
In the book list, I can see all the books, all the columns (including teh custom columns), however, teh custom columns are empty, i.e. the data that I had (before restoration) is missing.
|
![]() |
![]() |
![]() |
#12 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 31,025
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
I don't know how it would behave doing piece meal.
Kovid would need to really say. I suspect you would destroy the metadata.db, restore the json and all the metadata.opf's, then rebuild WAIT for the GURU to bless this plan That will leave those items added after the backup to be redone |
![]() |
![]() |
![]() |
#13 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,320
Karma: 27111242
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
If you have a backup use it to restore your library again. Restoring will restore custom columns and their data. The only way I knowof for that to fail is if you didnt actually do a restore but instead re-added the books to a library without the custom columns.
|
![]() |
![]() |
![]() |
#14 |
Member
![]() Posts: 13
Karma: 10
Join Date: Nov 2023
Device: Calibre
|
Thank you so much, Kevin, for chiming in!
When you say "If you have a backup use it to restore your library again", doesn't that mean doing that through Library > Library Maintenance > Restore Database on the main library folder? (which what I have already done) or do you mean doing Library > Library Maintenance > Restore Database using a backup folder from x number of days before the library stopped loading normally? |
![]() |
![]() |
![]() |
#15 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 10,941
Karma: 74999999
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Not 'restore database'. Deleting the entire library and restoring it from a backup.
|
![]() |
![]() |
![]() |
Tags |
custom columns, restore database |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restore custom columns? | the_Pan | Library Management | 12 | 10-17-2022 02:11 AM |
Ratings Custom Columns Created From other Columns | Tanjamuse | Library Management | 4 | 09-28-2020 12:57 AM |
Custom sort order for custom columns? | matjojo | Library Management | 5 | 11-24-2019 11:30 AM |
Help Needed for Custom Columns Created From other Columns | Tanjamuse | Library Management | 5 | 09-02-2018 06:19 PM |
[Kindle] On device - how to restore columns? | AussieTupp | Devices | 15 | 04-16-2017 08:43 AM |