Messed up database

Dannisa · 03-10-2019, 05:13 AM

I had my library of some 700 Photography e-books in perfect order and added my own tags, categories etc so that I could find any book on any topic.

Unfortunately I had my e-book sub folder on my OneDrive (Microsoft) and wanted to access it from my desktop computer instead of my laptop where I had done all the hard work.

I know appear to have messed up the metadata somewhat. In Calibre the book shows up with a Generic cover, and if I click on it I get a message saying that the book has no available formats, however, if I look in the actual sub-directory I can see 3 files: Cover.jpg, metadata.opf, and the pdf of the ebook.

Is there a program available that can read the ebook directory and restore the information or do I have to go through each book and redo it.

Thanks heaps.
Christina

theducks · 03-10-2019, 10:57 AM

1) stop the sync. 2 way sync is what got you in this mess. (a backup sync may be OK, but pause it when using Calibre, as it can lock files that
Calibre may be trying to update)

2) BACKUP what you have (just in case step 3 goes south)

3) On the Library Icon: Library Maintenance: Restore Database. This reads those OPF files you saw and rebuilds the DB

IF that fails DO NOTHING ELSE until you check back here. Every false step hurts a full recovery task

Dannisa · 03-11-2019, 10:49 PM

Thank you. I will try that now.

HarryT · 03-12-2019, 04:45 AM

Now you know why there are repeated warnings NOT to have your Calibre library on a network or Cloud drive! You may get away with it for a while, but sooner or later you'll screw it up. DON'T put your library on a Cloud drive. If you want to back it up to the Cloud, use a sync tool to copy it there.

03-10-2019, 05:13 AM	#1
Dannisa Junior Member Posts: 3 Karma: 10 Join Date: Mar 2019 Device: none	Messed up database I had my library of some 700 Photography e-books in perfect order and added my own tags, categories etc so that I could find any book on any topic. Unfortunately I had my e-book sub folder on my OneDrive (Microsoft) and wanted to access it from my desktop computer instead of my laptop where I had done all the hard work. I know appear to have messed up the metadata somewhat. In Calibre the book shows up with a Generic cover, and if I click on it I get a message saying that the book has no available formats, however, if I look in the actual sub-directory I can see 3 files: Cover.jpg, metadata.opf, and the pdf of the ebook. Is there a program available that can read the ebook directory and restore the information or do I have to go through each book and redo it. Thanks heaps. Christina

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Database got messed up	jhempel24	Calibre	5	10-19-2014 12:23 AM
I think I messed up	phynes	Introduce Yourself	4	07-17-2012 02:33 AM
I messed up	Rie142	Library Management	0	06-24-2011 01:04 PM
Calibre Database cp Kindle Database	mitch13	Library Management	1	05-22-2011 07:33 PM
HELP, I've messed up my K3!	PG4003	Amazon Kindle	9	12-16-2010 11:33 PM

03-10-2019, 10:57 AM	#2
theducks Well trained by Cats Posts: 30,944 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	1) stop the sync. 2 way sync is what got you in this mess. (a backup sync may be OK, but pause it when using Calibre, as it can lock files that Calibre may be trying to update) 2) BACKUP what you have (just in case step 3 goes south) 3) On the Library Icon: Library Maintenance: Restore Database. This reads those OPF files you saw and rebuilds the DB IF that fails DO NOTHING ELSE until you check back here. Every false step hurts a full recovery task

03-11-2019, 10:49 PM	#3
Dannisa Junior Member Posts: 3 Karma: 10 Join Date: Mar 2019 Device: none	Thank you. I will try that now.

03-12-2019, 04:45 AM	#4
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383099 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	Now you know why there are repeated warnings NOT to have your Calibre library on a network or Cloud drive! You may get away with it for a while, but sooner or later you'll screw it up. DON'T put your library on a Cloud drive. If you want to back it up to the Cloud, use a sync tool to copy it there.

Advert