All filenames were changed to lowercase, can I bulk edit database to correct the path

[Nirodha]

I recently moved my libraries from my Windows desktop to a Debain media server. I stupidly bulk renamed all my files/folders for avoid case-sensitivity problems going forward. This was fine for my other purposes (e.g. Plex data) because the databases are rebuilt quickly and easily. But my Calibre database has tons of hand edited values from years of use. I could rebuild from scratch, but I'm hoping there's a way to just change the paths to lower in the existing db. I tried doing it using sqlite3, but keep running in to "no such function: title_sort", I'm not sure why. I assume it's a custom function.

Can I use calibredb to edit these paths?

[theducks]

I am not sure this will help;
Quality check plugin: Fix: Check and rename book paths.

[kovidgoyal]

Create a new empty calibre library, then right click the add books button and choose add books from folders and sub folders and then one book per folder and select the old library folder, it will re-create your library restoring all metadata.

[modismos]

Originally Posted by kovidgoyal

Create a new empty calibre library, then right click the add books button and choose add books from folders and sub folders and then one book per folder and select the old library folder, it will re-create your library restoring all metadata.

I was also facing the same problem.
I tried to create a new library as you mentioned, and it worked.

Thanks for the help.
Elena

[Nirodha]

That worked! Thank you!
I'm so grateful for Calibre and all your efforts and that of all the volunteers in maintaining it.