Move Viewstate/Ratings from One Install to Another Issue

[furflix]

Hi @MovieFan.Plex ! It didn’t work Here is the result:

root@furflix:/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases# "/usr/lib/plexmediaserver/Plex Media Server" --sqlite com.plexapp.plugins.library.db
SQLite version 3.35.5 2021-04-19 18:32:05
Enter ".help" for usage hints.
sqlite> delete * from metadata_item_settings;
Error: near "*": syntax error
sqlite> select count(id) from metadata_item_settings;
3
sqlite> 

I tried to re-import it and now it’s showing:

root@furflix:/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases# "/usr/lib/plexmediaserver/Plex Media Server" --sqlite com.plexapp.plugins.library.db
SQLite version 3.35.5 2021-04-19 18:32:05
Enter ".help" for usage hints.
sqlite> delete * from metadata_item_settings;
Error: near "*": syntax error
sqlite> select count(id) from metadata_item_settings;
11339
sqlite> 

[furflix]

I finally could do it, but I remove the *!

"/usr/lib/plexmediaserver/Plex Media Server" --sqlite com.plexapp.plugins.library.db
delete from metadata_item_settings;
select count(id) from metadata_item_settings;
.quit
cat settings.sql | "/usr/lib/plexmediaserver/Plex Media Server" --sqlite com.plexapp.plugins.library.db

Thank you guys!!