I'm going through and cleaning up my data in Bookpedia (5.1.0), specifically the genre data. I've gone into my Library, limited which Genre's are actually in use, then I go to Preferences > Autofill > Genre > Rebuild and find that I've got a ton of genre entries still listed that do not exist in my database anywhere I can find. And I can't get rid of them. I've tried closing Bookpedia and deleting autofill.xml but it always gets regenerated the exact same way with the same non-existant genres.
As a test, I did an export of my current data, and then imported it to a clean copy Bookpedia. In this case, the genre data stayed clean! So I believe there's some type of garbage data stored in my old database file. While I can go through and do an export/import and not lose the raw data, so far I haven't found a way to transfer such things as smart folders, of which I have a lot of. I should note that I've gone through multiple upgrades of Bookpedia (I think I started back on 3.x) so there's probably some legacy cruft in my current database file. (As a seasoned Linux Admin, I have a theory that no matter how careful or clean your data is, cruft just grows like fungus in your datastore.... but that's for another discussion ;)
So before I go through do an export/import to a clean DB and then manually re-create all my smart folders, do you have any recommendations here? What I would really like to be able to do is do a complete dump of my database: raw data, smart folder configurations, and what ever else would be appropriate. (I really need to write a SQLite data dumper for myself...)
BTW, I think my issue appears to be related to this post: viewtopic.php?f=5&t=3443