MobileRead Forums - View Single Post - Where can I find "author_name_suffixes" in recovered database

AfterHours · 09-30-2020, 02:35 PM

I entered a million of these "author_name_suffixes" in my Win10 Calibre program's settings (Preferences > Advanced > Tweaks > Author sort name algorithm) before my Windows 10 User Profile was corrupted back in March 2020. I recovered the old metadata.db of the library along with many of the configuration files and saved these to a backup drive. I've scanned these files by opening copies of them in Notepad++ but can't find my custom prefixes anywhere. All of the books I had & their Calibre folder structure was corrupted or lost but I had the books backed up to the cloud in pdf format w .opf files. I am now running Calibre 4.23.0. The built-in functions to open the metadata.db file aren't working out for me and I've also tried opening the old database in DB Browser for SQLite to no avail. I'm really just looking for a little bit of text, as I had customized these prefixes substantially over time.

Thanks in advance.

09-30-2020, 02:35 PM	#1
AfterHours Junior Member Posts: 1 Karma: 10 Join Date: Sep 2020 Device: Calibre on Windows 10	Where can I find "author_name_suffixes" in recovered database I entered a million of these "author_name_suffixes" in my Win10 Calibre program's settings (Preferences > Advanced > Tweaks > Author sort name algorithm) before my Windows 10 User Profile was corrupted back in March 2020. I recovered the old metadata.db of the library along with many of the configuration files and saved these to a backup drive. I've scanned these files by opening copies of them in Notepad++ but can't find my custom prefixes anywhere. All of the books I had & their Calibre folder structure was corrupted or lost but I had the books backed up to the cloud in pdf format w .opf files. I am now running Calibre 4.23.0. The built-in functions to open the metadata.db file aren't working out for me and I've also tried opening the old database in DB Browser for SQLite to no avail. I'm really just looking for a little bit of text, as I had customized these prefixes substantially over time. Thanks in advance.