The Plex Media Server has been setup on Ubuntu from the Store. It seems to be a snap setup. I’m now trying to transfer ratings and watched status from a Windows PC. I followed this guide:
I have been able to create the settings.sql file for transfer. But I can’t modify the db file in Ubuntu since its located in the snap folder.
As I understand, snaps are something that are based on a read-only system and use a different file system. If a file has to be modified it has to be placed in a suitable directory by the developer.
Basically I just want to transfer ratings and watched status. Not very keen on trakt. So how do I go about doing this? Any help appreciated.
The actual path you want, with Plex stopped (of course) is in /var.
You must drill down into /var/snap/plexmediaserver/current and on further down into Plug-in Support/Databases.
There you will find the com.plexapp.plugins.library.db file
you must manually insert the exported SQL file contents into the file here (plex stopped of course)
/var/snap/plexmediaserver/common/Library/Application Support/Plex Media Server/Plug-in Support/Databases
I got a read only error. I was able to resolve that by changing the permissions of the parent directory. Details on that are here.
One small issue I did ran into, even though I see my ratings and views transferred correctly. I got this output after running the command to transfer the settings.sql data.
user@Ubuntu:/var/snap/plexmediaserver/common/Library/Application Support/Plex Media Server/Plug-in Support/Databases$ sudo cat settings.sql | sqlite3 com.plexapp.plugins.library.db
Error: near line 4: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 358: index index_metadata_item_settings_on_account_id already exists
Error: near line 359: index index_metadata_item_settings_on_guid already exists
Error: near line 360: index index_metadata_item_settings_on_view_count already exists
Error: near line 361: index index_metadata_item_settings_on_view_offset already exists
Error: near line 362: index index_metadata_item_settings_on_skip_count already exists
Error: near line 363: index index_metadata_item_settings_on_rating already exists
Error: near line 364: index index_metadata_item_settings_on_last_viewed_at already exists
Error: near line 365: index index_metadata_item_settings_on_changed_at already exists
The SQL presumes the tables and index must be created because it’s a raw dump.
When inserting into an existing database, these type “Already Exists” errors are normal.
