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.

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"