Hey guys! Has anyone had success migrating a Plex server from Windows to Linux in recent years? I’m mostly concerned about losing watch history / users (having to reinvite).
I found this Reddit thread on the issue and it seemed like a simple copy and paste of the DB file. I attempted following both the official directions from their guide and from the Reddit post and ran into a SQLite DB error similar to what another user experienced in the Reddit thread:
soci::soci_error() that sqlite3 prepare failed…Error: Unable to set up server: sqlite3_statement_backend::prepare: file is not a database for SQL: PRAGMA cache_size=512 (N4soci10soci_errorE)
Has anyone done a migration in the recent years? Seems like something might have changed within the last few and this copy and paste of the DB file will not work anymore?
Everything was freshly installed and updated including the OS (PopOS as I’m running it on my gaming PC)
Is the windows side up to date? Most likely culprit would be a db mismatch if one side or the other is on a different version. Similarly, do you by chance have either side running a beta release? If you have plex pass you potentially have access to these
Shameless moment to plug the idea that you could consider migrating to Jellyfin if you can’t solve the issue
Check the database version on both sides to make sure they match.
Pop OS currently is keeping the next version update on alpha as they’re developing their own compositor display stack called COSMIC to go along with it; so some database dependencies might have outdated versions.