View Single Post
Old 01-08-2014, 06:15 PM   #6
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,843
Karma: 30277270
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by manawydan View Post
Both drives are NTFS. In fact all my harddisc are NTFS.
Well that's a blessing

Quote:
Originally Posted by manawydan View Post
Just a thought - would it be of use to rename or move the db and copy the backup-ed db into the folder instead?
And somehow remove the files in the library that were added after the backup and therefor not in this backup version of the db?
Yes maybe - but do it on a copy of library, make sure you keep the corrupt library intact :

Quote:
Originally Posted by theducks View Post
Caution: don't do anything until Kovid responds... There might be a recovery that is faster than starting over.
A Calibre library is the entire library folder - ie the author and book folders, the metadata.db and any other files you see there. You should always backup the library folder and everything in it - yes it takes a bit longer, but if you use something like FFS and you do it regularly its not too onerous.

So, copy that backup of metadata.db into the library copy (overwrite the one that's there) now try to start calibre, if it starts run the Library Maintenance->Check Library function - both phases. The second phase should tell you which books are in the library folder but not in the database.

You could move those book folders out of library and use them as the source to re-add the books

Or you could try running Library Maintenance->Restore database function - warning this may take a long time and it may not solve the problem.

Quote:
Originally Posted by manawydan View Post
I have asked different people if Calibre has a limit it can handle but everybody said no.
But either it has or there was a problem with the db or disc .. hm.
The limits are more likely to be imposed by the file system and the SQLite database, and I think you're a long way short of those.

When you add books to calibre then, depending on the Add Books config settings you have, calibre will read the format files - its always possible that one of the format files has led to the database corruption - I'm not aware that it's ever happened, but with 3.5m active users how would anyone know.

BR

Last edited by BetterRed; 01-08-2014 at 06:17 PM.
BetterRed is offline   Reply With Quote