I’m running the current latest version, and am trying to move the history from one Plex server to another.
I have copied all of my media, and setup a new server using Unraid and Docker on new hardware. I have configured my new server, and everything is working as expected, the only thing missing is the watched history, which I’m really keen to retain, as I’ve been using my server for several years, and have several family members who share these libraries.
I originally tried to follow the migration process documented here, but found everytime that the database was corrupted after using DB Browser for SQLLite to modify the fields as required for the different path. Without updating the paths Plex wouldn’t load at all.
I have also tried to follow the instructions in this article, but as I’m running on Windows and not Linus or MacOS, then the grep commands don’t work, so I can’t run the command included.
Any guidance on how to execute the following on Windows, so that I can migrate the watched status would be awesome.
Extract from Windows install
echo ".dump metadata_item_settings" | sqlite3 com.plexapp.plugins.library.db | grep -v TABLE | grep -v INDEX > settings.sql
Import in to Docker install
cat settings.sql | sqlite3 com.plexapp.plugins.library.db
