3 hours ago
I tried to modify the SQlite database like this:
tja@mini:~/Library/Application Support/jellyfin/data$ sqlite3 library.db
SQLite version 3.47.0 2024-10-21 16:30:22
Enter ".help" for usage hints.
sqlite> .output library.sql
sqlite> .dump
sqlite> .exit
tja@mini:~/Library/Application Support/jellyfin/data$ sed 's@/T7_Touch1TB/MOVIES@/XTRMQ/MEDIA/MOVIES@g;s@/T7_Touch1TB/SERIES@/XTRMQ/MEDIA/SERIES@g;s@/T7_Touch1TB/INTERNET@/XTRMQ/MEDIA/INTERNET@g;s@/T7_Touch1TB/PRIVATE@/XTRMQ/MEDIA/PRIVATE@g' library.sql > library.new
tja@mini:~/Library/Application Support/jellyfin/data$ sqlite3 library2.db
SQLite version 3.47.0 2024-10-21 16:30:22
Enter ".help" for usage hints.
sqlite> .read ./library.new
sqlite> .exit
tja@mini:~/Library/Application Support/jellyfin/data$ mv library2.db library.db
tja@mini:~/Library/Application Support/jellyfin/data$ rm library.sql library.new
Then I started Jellyfin again and scanned all media libraries.
Result:
All content gone from Jellyfin, totally.
If I want to continue, I need to seek out the docs I found before and also check the old Python script, even as this was for Windows and Docker.
As I said: Horrible!
tja@mini:~/Library/Application Support/jellyfin/data$ sqlite3 library.db
SQLite version 3.47.0 2024-10-21 16:30:22
Enter ".help" for usage hints.
sqlite> .output library.sql
sqlite> .dump
sqlite> .exit
tja@mini:~/Library/Application Support/jellyfin/data$ sed 's@/T7_Touch1TB/MOVIES@/XTRMQ/MEDIA/MOVIES@g;s@/T7_Touch1TB/SERIES@/XTRMQ/MEDIA/SERIES@g;s@/T7_Touch1TB/INTERNET@/XTRMQ/MEDIA/INTERNET@g;s@/T7_Touch1TB/PRIVATE@/XTRMQ/MEDIA/PRIVATE@g' library.sql > library.new
tja@mini:~/Library/Application Support/jellyfin/data$ sqlite3 library2.db
SQLite version 3.47.0 2024-10-21 16:30:22
Enter ".help" for usage hints.
sqlite> .read ./library.new
sqlite> .exit
tja@mini:~/Library/Application Support/jellyfin/data$ mv library2.db library.db
tja@mini:~/Library/Application Support/jellyfin/data$ rm library.sql library.new
Then I started Jellyfin again and scanned all media libraries.
Result:
All content gone from Jellyfin, totally.
If I want to continue, I need to seek out the docs I found before and also check the old Python script, even as this was for Windows and Docker.
As I said: Horrible!