How to delete non-existent ebooks from database?
Hi all,
I have deleted many files in the calibre library directory (not the directories and the metadata.opf files), not within calibre itself. Before someone asks why I did this way, the reason in the library were file formats which I didn't want like .txt or .zip files or small size .pdf files and it was easy for me to mark and delete all these kind of files with a file manager.
Now there are inconsistencies in the database since the actual files are missing.
When I go to Library - Library Maintenance - Check Library I can see in the "Missing book formats" the problematic entries. I want to delete all these entries but there are no check boxes next to them. I could delete all these entries manually by using the id and searching for each entry but this is time consuming. I wonder why there is are no check boxes beside the "Missing book formats" (there is only "fixable") and why the files can be marked by check boxes in the first place. This is OK for some entries but if someone like me has some hundreds of entries clicking one by one is not easily manageable.
So, is there any easy way to delete non-existent ebooks from database? What will happen if I just delete the directories together with the including metadata.opf files? Will the database get corrupted?
Any suggestions?
Thanks in advance!
|