Jellyfin – Migrating Users

I’m moving from a Windows based instance of Jellyfin to a containerized instance within CasaOS, and I wanted to preserve user data (including view history). Here’s how I did it:

• Confirm both your source and destination Jellyfin are the same version
• Export the UserDatas table from library.db for your source instance. You can use DB Browser for SQLite to achieve this – remember to check “Column names in first line”
• On your destination server, make a backup of library.db and jellyfin.db
• Again using DB Browser, open the library.db of your destination server. Drop the UserDatas table and import csv created in the prior step to recreate the table (remember to check that the first line contains the column names)
• Copy jellyfin.db from your source server and overwrite the db from the destination with it. This is important, as this file contains user history data
• Fire your new Jellyfin instance up and attempt to log in with an existing user