Datebase corrupt and would not restore all books

kchichester · 08-06-2021, 03:50 PM

How do I restore all of my books if the DB won't recognize more than 24 of the 3000 or so I have in there? Is there an easy way to put all of the files back into the database. I have years worth of work that I don't want to lose.

This all started when Calibre wouldn't launch today. I folowed the directions in the manual and deleted the database metafile and relaunched the Calibre. It would recognise the library, so I tried restore and only go 24 books. out of 3000+.

Runing Window 64 bit on Windows 10.

Thanks.

theducks · 08-06-2021, 04:03 PM

Be sure your Library is on a local drive: (no NAS or shares)
You used the Restore Database item under Library Maintenance?

kchichester · 08-06-2021, 04:04 PM

I should say that all of the books contain their own metadata files.

theducks · 08-06-2021, 04:09 PM

Quote:

Originally Posted by kchichester

I should say that all of the books contain their own metadata files.

metadata.opf is what Calibre restore USES to rebuild the DB as well as
metadata_db_prefs_backup.json, which is the Structure (as customized) of what the DB should have.

If that is gone, you only get the default fields upon restore

kchichester · 08-06-2021, 04:13 PM

Quote:

Originally Posted by theducks

Be sure your Library is on a local drive: (no NAS or shares)
You used the Restore Database item under Library Maintenance?

I used the Restore Database itens under Libray Mantainance. My library and Calibre was running well with the Library located in One Drive. Then my hard drive got corrupted and was replaced. l

Will moving it to a new location on my hard drive fix this issue?

kchichester · 08-06-2021, 04:19 PM

Quote:

Originally Posted by theducks

metadata.opf is what Calibre restore USES to rebuild the DB as well as
metadata_db_prefs_backup.json, which is the Structure (as customized) of what the DB should have.

If that is gone, you only get the default fields upon restore

The orginals were overwritten when I tried to restore. I do have the pre restore meta file that Calibre created in there.

I am really only concernced that I get the books and the basic meta data. I had tons of customizations that I have come to terms with losing. How do I get Calbre to recognize the other books. The move to the harddrvie only took the books that were in the "new" smaller library.

Would I use the "Add Books" function pull the metadata for each book from it's folder?

kchichester · 08-06-2021, 10:40 PM

I discovered the latest update of Calibre is causing some windows 10 users to have Calibre not launch. Reinstalling an older version fixes that issue, so I though I would experiment since I had little to lose.I got it fixed.

1. Installed an older version.
2. Manually moved all books (in their folders) into the "new" library folder.
3.Moved the current "metadata" and the" metadata_db_prefs_backup.json" files out of the "new" library file into a random folder.
4. Left the "metadata_pre_restore" file in the new library folder.
5. Then renamed it "metadata".
6.Ran Restore Database from Library Management and it worked.

All books and preferences were restored.
Thanks for your help.

08-06-2021, 03:50 PM	#1
kchichester Junior Member Posts: 6 Karma: 10 Join Date: Apr 2012 Device: iPad	Datebase corrupt and would not restore all books How do I restore all of my books if the DB won't recognize more than 24 of the 3000 or so I have in there? Is there an easy way to put all of the files back into the database. I have years worth of work that I don't want to lose. This all started when Calibre wouldn't launch today. I folowed the directions in the manual and deleted the database metafile and relaunched the Calibre. It would recognise the library, so I tried restore and only go 24 books. out of 3000+. Runing Window 64 bit on Windows 10. Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre books corrupt in Apple Books	kwills341	Calibre	3	10-27-2019 10:05 PM
Desktop App - Books locked or corrupt	brudigia	Kobo Reader	12	05-26-2014 03:48 PM
uploaded books are corrupt and missing meta data	PeterKennedy	Calibre	1	10-10-2012 01:14 AM
Odyssey corrupt filesystem, no books show up.	frymaster	Bookeen	7	09-10-2012 05:51 PM
Corrupt Books in the Sony Reader Store	phazlehurst	Sony Reader	1	01-16-2010 11:26 AM

08-06-2021, 04:03 PM	#2
theducks Well trained by Cats Posts: 30,018 Karma: 57259778 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Be sure your Library is on a local drive: (no NAS or shares) You used the Restore Database item under Library Maintenance?

08-06-2021, 04:04 PM	#3
kchichester Junior Member Posts: 6 Karma: 10 Join Date: Apr 2012 Device: iPad	I should say that all of the books contain their own metadata files.

08-06-2021, 10:40 PM	#7
kchichester Junior Member Posts: 6 Karma: 10 Join Date: Apr 2012 Device: iPad	I discovered the latest update of Calibre is causing some windows 10 users to have Calibre not launch. Reinstalling an older version fixes that issue, so I though I would experiment since I had little to lose.I got it fixed. 1. Installed an older version. 2. Manually moved all books (in their folders) into the "new" library folder. 3.Moved the current "metadata" and the" metadata_db_prefs_backup.json" files out of the "new" library file into a random folder. 4. Left the "metadata_pre_restore" file in the new library folder. 5. Then renamed it "metadata". 6.Ran Restore Database from Library Management and it worked. All books and preferences were restored. Thanks for your help.

Advert

Advert