[ygreq]

Hi folks!

I have been using Calibre since forever. And I always had this issue which is weird that it has not been solved till now.

I have a Calibre book library of about 60 000 books. And from time to time, the metadata.db gets corrupted. Usually this happens when I use the library to write something in it (like adding a new book or editing some book metadata or book title).

And whenever I try to do Library Maintenance -> Restore database, it takes like forever. Seriously it takes more than 3 days full 72 hours) or maybe more.

So considering that considering what I said about the probable reason why this database file gets corrupted is because of what I last did before actually corrupting itself, I was thinking that a backup copy of the metadata.db not older than a few minutes would definitely help in solving the issue a lot easier.

I would just:
-close Calibre
-delete the old corrupted metadata.db file,
-rename the backup file
-restart Calibre
-readd the book I was trying to add, or modify again the book details I was trying to modify. (All this would be based on "Modified" column sorting)

So any idea if this can be done? To have Calibre do a backup of metadata.db every 5 minutes? Or set the time in the Settings on how frequently you would want to do the backup.

So what do you say? Does it make sense?
Let me know!

PS: I was looking for 3rd party apps to backup files, but all the apps I found can backup a whole folder. So if you know of an app like that, it would be way around. At least until this hopefully gets solved. <3