So here's what I had to do, not pretty but better than going through my entire Calibre db one author at a time.
I have restored the last known "good" Calibre db from November 5th from Time Machine. My system didn't go crazy until the 6th.
I did look at the books and I noticed that many of my very early books have multiple epub copies, so once the database is restored, I will go in a do what many have suggested which is run the Quality Check plug-in for a number of items. For example, I will have an author twice in Calibre that looks like this:
Smith, Jane
Smith_Jane
I noticed that the Quality Check plug-in finds those folders without commas, etc. I really think this boils down to a lack of db maintenance on my part. I thank EVERYONE for some very good suggestions and will let you know how things turn out.
|