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?
Just to add to the info so far: while you’re spending the effort doing a migration it’s worth going the extra few steps and moving to their Docker image. It’ll make any future server moves a doddle, not to mention updates etc.
How does a doddle compare to a jiffie?
Doodle is a bit more artistic, while jiffie is a bit more poetic. I haven’t found any practical differences in deployment.
Doddle = easy Jiffie = quick
Marines quite: “It might be quick, but it ain’t easy.”
Can recommend the Linuxserver.io version – I found it easier in podman to implement nvidia hardware decoding with the linuxserver.io version than with the official image.
Ended up setting this up and it was fairly straight forward, thanks for the recommendation!
Agreed. I use their docker image, and have migrated servers. Other than copying data it only took a few minutes of cli-fu and everything was back up and running.