Re-importing Library after corrupt metadata.db

samhain · 03-07-2011, 11:06 AM

Hello,

My metadata.db file became corrupted. I tried recovering it with sqlite3, but there are errors when doing that -- I figure it is toast.

So, Calibre is restarted with zero books, but I have the old directory structure with all the files including the metadata.opf's. How can I go about re-importing all of this into Calibre? It does not appear that a standard import will work. Perhaps if I imported each Authors directory individually? But I am hoping there is a less tedious way.

I did a search of the forums, but could not find anything. Although I might have not searched the appropriate words.

Thanks in advance.

- Steven

kovidgoyal · 03-07-2011, 11:10 AM

click the arrow next to the calibre icon on the toolbar and select library maintenance->restore library.

samhain · 03-07-2011, 12:31 PM

That did it!

Thanks!

Starson17 · 03-07-2011, 01:57 PM

Quote:

Originally Posted by samhain

That did it!

Thanks!

Do you know how your metadata.db became corrupt? I've done all sorts of awful things to my library, and have yet to corrupt it. It seems pretty resilient, but if you've got any tips on what to avoid, I'm interested.

03-07-2011, 11:06 AM	#1
samhain Junior Member Posts: 8 Karma: 10 Join Date: Apr 2009 Device: kindle	Re-importing Library after corrupt metadata.db Hello, My metadata.db file became corrupted. I tried recovering it with sqlite3, but there are errors when doing that -- I figure it is toast. So, Calibre is restarted with zero books, but I have the old directory structure with all the files including the metadata.opf's. How can I go about re-importing all of this into Calibre? It does not appear that a standard import will work. Perhaps if I imported each Authors directory individually? But I am hoping there is a less tedious way. I did a search of the forums, but could not find anything. Although I might have not searched the appropriate words. Thanks in advance. - Steven

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing the Calibre library into the Sony Reader Library	Fortissimo	Reading and Management	0	02-02-2011 02:18 PM
My Metadata file seems corrupt	gandor62	Calibre	3	03-27-2010 08:40 PM
Importing - Metadata aquisition	Justy	Calibre	1	02-05-2010 03:44 PM
corrupt metadata.db and redoing library	Dopedangel	Calibre	6	01-01-2010 04:49 PM
PC based software library corrupt	exvaxman	Sony Reader	4	11-13-2006 03:29 PM

03-07-2011, 11:10 AM	#2
kovidgoyal creator of calibre Posts: 45,163 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	click the arrow next to the calibre icon on the toolbar and select library maintenance->restore library.

03-07-2011, 12:31 PM	#3
samhain Junior Member Posts: 8 Karma: 10 Join Date: Apr 2009 Device: kindle	That did it! Thanks!

Advert