Calibre corupt DB, my last backup April help

crochetgeek2010 · 05-11-2015, 09:29 PM

Hi,
I have one for you. Manged to corrupt my calibre meta data db

. restore and fix did not work. I had my backup from April on USB drive

. Only issue is I have added books and fixed the meta data in the last 30+ days. Geek in me said run scan and it will fix it. all that successfully did was give me a huge list of oops. I know I did not do that much. Any way to get it to scan in and reclaim my files easily or do I have import each one again? your help is greatly appreciated

.

Laura

eschwartz · 05-11-2015, 09:44 PM

Add books ==> Add books from directories, including sub-directories (One book per directory, assumes every ebook file is the same book in a different format)

this can import books saved with save-to-disk as well as from a messed-up library, it reads data from the backup metadata.opf file as well. Run that (from a blank library) on your entire old library to recreate the old library. (Partially --some things won't be restored, including custom columns and other settings.)

Afterward, use the Find Duplicates plugin to cleanup and merge with the backup.
Then start taking backups more often.

I assume restore database failed because of duplicate book ids or something?

crochetgeek2010 · 05-11-2015, 09:47 PM

Not sure why it failed just told me corrupt every blasted time. I admit I get slightly impatient as an IT geek with ADHD (you would think it would get better with age). Any chance that will keep the meta data - I have a habit of renaming books with series first then number so I can find them easier in my ereader. Thanks

eschwartz · 05-11-2015, 09:52 PM

Like I said, if Restore Database (the preferred solution) fails, then importing the library root using the Add Books option I mentioned above will import all books including the saved metadata columns. If you have custom columns, the new library you are importing into must have those columns as well.

Feel free to describe exactly what the Restore reported when it failed

I am having a hard time picturing what you mean.

LadyKate · 05-19-2015, 04:46 AM

If you can still access your library you could use the modify epub plugin to save the metadata to the files changed since your backup. Then save these books to a single directory (assuming they are epubs).

This will result in the books having all the updated metadata when you import them into your restored library.

05-11-2015, 09:29 PM	#1
crochetgeek2010 Enthusiast Posts: 44 Karma: 13110 Join Date: Mar 2012 Device: Kobo Aura HD	Calibre corupt DB, my last backup April help Hi, I have one for you. Manged to corrupt my calibre meta data db. restore and fix did not work. I had my backup from April on USB drive. Only issue is I have added books and fixed the meta data in the last 30+ days. Geek in me said run scan and it will fix it. all that successfully did was give me a huge list of oops. I know I did not do that much. Any way to get it to scan in and reclaim my files easily or do I have import each one again? your help is greatly appreciated. Laura

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What do I backup for calibre settings	LadyKate	Library Management	2	02-04-2014 07:46 PM
Calibre backup issue	djeady	Related Tools	0	12-12-2012 10:03 AM
Remote Calibre Backup?	jamng	Related Tools	3	12-09-2011 08:50 AM
Several questions regarding Calibre Backup	inkyichi	Related Tools	4	08-01-2011 04:41 PM
Backup for Calibre	dee1952	Related Tools	14	02-10-2011 09:56 AM

05-11-2015, 09:44 PM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Add books ==> Add books from directories, including sub-directories (One book per directory, assumes every ebook file is the same book in a different format) this can import books saved with save-to-disk as well as from a messed-up library, it reads data from the backup metadata.opf file as well. Run that (from a blank library) on your entire old library to recreate the old library. (Partially --some things won't be restored, including custom columns and other settings.) Afterward, use the Find Duplicates plugin to cleanup and merge with the backup. Then start taking backups more often. I assume restore database failed because of duplicate book ids or something?

05-11-2015, 09:47 PM	#3
crochetgeek2010 Enthusiast Posts: 44 Karma: 13110 Join Date: Mar 2012 Device: Kobo Aura HD	Not sure why it failed just told me corrupt every blasted time. I admit I get slightly impatient as an IT geek with ADHD (you would think it would get better with age). Any chance that will keep the meta data - I have a habit of renaming books with series first then number so I can find them easier in my ereader. Thanks

05-11-2015, 09:52 PM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Like I said, if Restore Database (the preferred solution) fails, then importing the library root using the Add Books option I mentioned above will import all books including the saved metadata columns. If you have custom columns, the new library you are importing into must have those columns as well. Feel free to describe exactly what the Restore reported when it failed I am having a hard time picturing what you mean.

05-19-2015, 04:46 AM	#5
LadyKate Fanatic Posts: 515 Karma: 1470724 Join Date: Jul 2013 Location: Quebec CA Device: android 4 (samsung tablet and asus tablet)	If you can still access your library you could use the modify epub plugin to save the metadata to the files changed since your backup. Then save these books to a single directory (assuming they are epubs). This will result in the books having all the updated metadata when you import them into your restored library.

Advert

Advert