Move Viewstate/Ratings from One Install to Another

Hello,

I am trying to execute exactly what this article says and I meet all requirements. I have a Mac with SQL Lite 3. However, when I execute the first command, instead of getting settings.sql, I am getting com.plexapp.plugins.library.db-shm and com.plexapp.plugins.library.db-wal.

Can anyone guide me? Much appreciate it.


Screen Shot 2022-05-06 at 2.13.51 AM

Those instructions need to be updated. Plex made changes to the database that prevents the standard sqlite3 program from being able to modify a database. Plex has provided it’s own SQL command tool “Plex SQLite” in the executable folder. Use that instead.

1 Like

Plex SQLite isn’t strictly needed for this procedure. That table doesn’t have database extensions.

That command creates a file settings.sql in the directory where the command was executed, not the same directory as the database file.

After running it, what does ls ./settings.sql show? Was a file created?

What directory is the command line currently in? Use pwd to show it.

For reference, Plex SQLite is located here on macOS:

"/Applications/Plex Media Server.app/Contents/MacOS/Plex SQLite"

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