Restore Database?

BookJunkieLI · 08-15-2014, 01:02 PM

I had a power outage in the middle of doing a large import the other night. So I ran Check Library and I have roughly 3k books listed as Extra Titles. They all had ID numbers and the random ones I looked at have a metadata.opf file.

I'm assuming my best option is to run Restore Database? I wanted to make sure before I run it because my library is currently sitting at 30 books shy of 57,000. I'm guessing it's going to take a looong time to run a restore database.

eschwartz · 08-15-2014, 01:18 PM

You could also delete the extra titles and then reimport. Probably be a lot faster, especially for a library that size.

BookJunkieLI · 08-15-2014, 02:49 PM

That's an idea but the problem I have is the import was only for about 1200 books. These are almost all fanfics which means I imported them using FFDL and their url. I still have the urls for the last batch, so I could re-import those, but no clue what the urls for all the other ones would be.

I'm wondering, what if I copied all of those extra title folders into an empty library based on the same column structure and then ran a Restore Database on that library before copying them into the original library? It's still a large amount of work but it seems less likely to run the risk of freezing my computer.

I'm also kind of curious as to why restoring extra titles to the database isn't an option in the check library process?

eschwartz · 08-15-2014, 02:53 PM

No need to Restore Database on the temp library, just copy those folders out and import them.

Are you going to copy them one by one?

BookJunkieLI · 08-15-2014, 05:04 PM

Quote:

Originally Posted by eschwartz

No need to Restore Database on the temp library, just copy those folders out and import them.

Are you going to copy them one by one?

But it doesn't import the metadata that's in the opf file. I know, because I did a couple of test imports.

Unfortunately.

The one good thing is a number of them have the same author but, yeah, still a pain.

eschwartz · 08-15-2014, 05:08 PM

See attached image. It will import metadata from the OPF -- that option was meant for re-importing calibre save-to-disk folders, in order to facilitate transfer between platforms I guess.

BookJunkieLI · 08-15-2014, 06:10 PM

Huh. I thought I'd used that option. I wonder if I'd used the one below it instead and that's why it didn't pull in the metadata. I'll give it a try.

08-15-2014, 01:02 PM	#1
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	Restore Database? I had a power outage in the middle of doing a large import the other night. So I ran Check Library and I have roughly 3k books listed as Extra Titles. They all had ID numbers and the random ones I looked at have a metadata.opf file. I'm assuming my best option is to run Restore Database? I wanted to make sure before I run it because my library is currently sitting at 30 books shy of 57,000. I'm guessing it's going to take a looong time to run a restore database.

08-15-2014, 05:08 PM	#6
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	See attached image. It will import metadata from the OPF -- that option was meant for re-importing calibre save-to-disk folders, in order to facilitate transfer between platforms I guess. Attached Thumbnails

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to restore a library with missing Database?	Poldi	Library Management	2	06-13-2013 05:09 AM
Restore Database fails - Exception: Something bad happened	bhoyt	Calibre	10	12-07-2012 09:27 AM
Restore Database?	BeeTee-Ess	Calibre	2	10-12-2012 07:40 AM
restore database help	mabee	Calibre	13	01-11-2011 02:16 PM

08-15-2014, 01:18 PM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	You could also delete the extra titles and then reimport. Probably be a lot faster, especially for a library that size.

08-15-2014, 02:49 PM	#3
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	That's an idea but the problem I have is the import was only for about 1200 books. These are almost all fanfics which means I imported them using FFDL and their url. I still have the urls for the last batch, so I could re-import those, but no clue what the urls for all the other ones would be. I'm wondering, what if I copied all of those extra title folders into an empty library based on the same column structure and then ran a Restore Database on that library before copying them into the original library? It's still a large amount of work but it seems less likely to run the risk of freezing my computer. I'm also kind of curious as to why restoring extra titles to the database isn't an option in the check library process?

08-15-2014, 02:53 PM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	No need to Restore Database on the temp library, just copy those folders out and import them. Are you going to copy them one by one?

08-15-2014, 06:10 PM	#7
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	Huh. I thought I'd used that option. I wonder if I'd used the one below it instead and that's why it didn't pull in the metadata. I'll give it a try.

Advert

Advert