Migrating watch history from old to new server

[cannfoddr]

Hi I am trying to follow this article on migrating server watch history from old to new server.

https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/

The article gives some sql to be run from the './Pugin Support/Databases/ directory:

echo ".dump metadata_item_settings" | sqlite3 com.plexapp.plugins.library.db | grep -v TABLE | grep -v INDEX > settings.sql

Now if I am reading this right there should be a hidden file called .dump.metadata_item_settings that I am piping out to an sqlite3 command shell - I have check the directory and there is NO such hidden file.

if I run the command the results look minimal and I can’t see how they reflect the watched state of the contents of my media library.

What am I missing here?

[anon5074910]

The process is using a sql dump command (.dump) from database com.plexapp.plugins.library.db and its table called metadata_item_settings into a file called settings.sql.

BTW… you might want to also review this thread for some additional context → Corrupt Database - Transferring User Information

You may also want to review this https://support.plex.tv/articles/sync-watch-state-and-ratings but I don’t use their sync feature myself and have chosen to keep it local in my database rather than their cloud.