Restoring Play Count

Server Version#: 1.25.4.5487

I recently migrated my Plex Server from my Raspberry Pi to Fedora. I followed instructions listed here (https://support.plex.tv/articles/201370363-move-an-install-to-another-system/) to set everything up.

The PMS is up and running and I can access my content, but it doesn’t seem as though all of my settings imported properly, namely my play counts. All of my content has been set back to “not played.” Where I have changed covers to movies and edited titles/content didn’t transfer either. I have also lost all of my playlists.

I still have the old data that I saved from my old PMS. What do I need to restore in order to get back all of my customized settings?

This is assuming the new servers content was match with the same agents as the old servers as view state is based on GUID, it is exporting from old DB and importing into new one

@BigWheel Thanks for the reply. I gave the guide a try. I was able to produce the SQL file on the source system and copied it into the same directory on the destination machine. However, when I ran that last command cat settings.sql | sqlite3 com.plexapp.plugins.library.db I get several errors that read “Error: near line ####: no such table: metadata_item_settings.” I started the server back up anyways just to check if it might have worked anyways.

Any idea what I might be doing wrong here?

That message implies that it isn’t being run against the new Plex database. This message would appear the command was run against an empty database.

Have you changed to the new Plex database directory before running it?

@Volts Thank you! I looked back and apparently I wasn’t running the command from the correct directory.

So that fixes my play counts, but what of my movie/shows covers? Those changed when I created the new server and did not update when copied over my old settings (not the settings.sql that BigWheel/Volts helped me with).

How do I get my movie/show covers back and where I have changed a title/episode name?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.