Score:0

Error when transferring Plex watch history from Windows 10 to Ubuntu 22.04

US flag

I have been running a Plex server on a Windows PC, and want to move over to an Ubuntu PC.

I'm trying to do this by just fresh installing Plex and moving over the watch history.

I followed the instructions from Plex to export the data here: https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/

I have the settings.sql file, but am having trouble importing it to my new Plex instance in Ubuntu.

When I execute the command:

cat settings.sql | sqlite3 com.plexapp.plugins.library.db

I get this error:

Error: near line 1: in prepare, near "��P": syntax error (1)

And here's a screenshot in case I made a typo: terminal screenshot

I'm lost on where to look or what to try next, any suggestions are appreciated.

David avatar
cn flag
I suggest you ask this on the Plex support forum as it has many entries on this.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.