Unable to restore databasecalibre - Page 2

Sirtel · Yesterday, 10:33 AM

Remove them and add them back using the Add Books button. Don't add them directly to the library folder.

theducks · Yesterday, 11:02 AM

the metadata.opf in each folder has the same info that was in the DB at the time the OPF was created. It is a snapshot that Restore uses. If it was wrong before, it is probably still wrong.
Adding books to a fresh Library is probably more likely to be correct.

asw22 · Yesterday, 12:36 PM

The problem is:

-I have no idea how many books are missing...unles there is a way to get the list of books registered in the database for comparison

- adding books means there are two folders of the same book...removable via utilities easily, but I understand it is not good

I do not understand the retoration of the database...when there are no database,Calibre mooks for books and associated metadat...so why take some and ignore others?

Sirtel · Yesterday, 12:48 PM

Quote:

Originally Posted by asw22

The problem is:

-I have no idea how many books are missing...unles there is a way to get the list of books registered in the database for comparison

Yes, there is. Create a new empty library and copy all the books in the old library to it via the GUI (NOT via the File Explorer or directly from the folder!): select all -> right-click -> copy to library (delete after copy). The book list in the old library should now be empty. Everything that remains in the library folder was not in the database and must be re-added via the Add Books button.

Quote:

I do not understand the retoration of the database...when there are no database,Calibre mooks for books and associated metadat...so why take some and ignore others?

Because obviously there is something wrong with those books and metadata.

asw22 · Yesterday, 04:38 PM

I have compared the opf of two books, one shown, the other not, the only apparent difference is the Calibre identifier (same as the number in folder title) and the uuid.

This is bizarre . But your suggestion is excellent, ongoing now...

asw22 · Today, 04:22 PM

Hello everyone!

I did transfer the 41 000 books or so from the library to a new one, and I did look what was left....still 11000 books to go!

I still do not understand what could have happened?

Not very enthusisastic at the idea of integrating directly the .epub in the new library, losing all metadata, I tried something:
- I restored the database of the library with the leftover books...and I got myself a library with 11000 books, and their correct metadata...11000 books calibre refused obstinately to show me before!!!

I transferred the books via the "copy to library + delete", and now I have all my books correctly shown in the new library...I had two books not transferred I did manually, and that was it!

I am happy and still baffled...

But thanks everyone, and if you have ideas about this mess let me know!

asw22

Sirtel · Today, 04:40 PM

Glad you got your library restored.

But yes, it would be good to know how this mess happened in the first place. Otherwise you might find yourself in the same pickle one day. The common culprits for messing up the database are syncing programs running in the background, moving files directly to/from the library folder without going through the calibre GUI, and faulty drives.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unable to restore backup from Google drive in Moonreader pro due to blocked access	archz2	Android Devices	0	05-12-2024 11:32 AM
iPhone 7 unable to restore Error 4013	Dean11	Apple Devices	1	10-23-2018 01:09 PM
version 3.15.0: unable to 'restore' database	BuPunkt	Library Management	4	01-18-2018 08:45 AM

Yesterday, 10:33 AM	#16
Sirtel Grand Sorcerer Posts: 10,820 Karma: 226728226 Join Date: Jan 2014 Location: Estonia Device: Kobo Sage & Libra 2	Remove them and add them back using the Add Books button. Don't add them directly to the library folder.

Yesterday, 11:02 AM	#17
theducks Well trained by Cats Posts: 30,169 Karma: 57532200 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	the metadata.opf in each folder has the same info that was in the DB at the time the OPF was created. It is a snapshot that Restore uses. If it was wrong before, it is probably still wrong. Adding books to a fresh Library is probably more likely to be correct.

Yesterday, 12:36 PM	#18
asw22 Junior Member Posts: 9 Karma: 10 Join Date: Aug 2024 Device: PocketBook InkPad 3	The problem is: -I have no idea how many books are missing...unles there is a way to get the list of books registered in the database for comparison - adding books means there are two folders of the same book...removable via utilities easily, but I understand it is not good I do not understand the retoration of the database...when there are no database,Calibre mooks for books and associated metadat...so why take some and ignore others?

Yesterday, 04:38 PM	#20
asw22 Junior Member Posts: 9 Karma: 10 Join Date: Aug 2024 Device: PocketBook InkPad 3	I have compared the opf of two books, one shown, the other not, the only apparent difference is the Calibre identifier (same as the number in folder title) and the uuid. This is bizarre . But your suggestion is excellent, ongoing now...

Today, 04:22 PM	#21
asw22 Junior Member Posts: 9 Karma: 10 Join Date: Aug 2024 Device: PocketBook InkPad 3	Hello everyone! I did transfer the 41 000 books or so from the library to a new one, and I did look what was left....still 11000 books to go! I still do not understand what could have happened? Not very enthusisastic at the idea of integrating directly the .epub in the new library, losing all metadata, I tried something: - I restored the database of the library with the leftover books...and I got myself a library with 11000 books, and their correct metadata...11000 books calibre refused obstinately to show me before!!! I transferred the books via the "copy to library + delete", and now I have all my books correctly shown in the new library...I had two books not transferred I did manually, and that was it! I am happy and still baffled... But thanks everyone, and if you have ideas about this mess let me know! asw22

Today, 04:40 PM	#22
Sirtel Grand Sorcerer Posts: 10,820 Karma: 226728226 Join Date: Jan 2014 Location: Estonia Device: Kobo Sage & Libra 2	Glad you got your library restored. But yes, it would be good to know how this mess happened in the first place. Otherwise you might find yourself in the same pickle one day. The common culprits for messing up the database are syncing programs running in the background, moving files directly to/from the library folder without going through the calibre GUI, and faulty drives.