Migrate from old Sinology NAS to a new NAS - can I just copy com.plexapp.plugins.library.db

[richard_martin]

Hi

Move Viewstate/Ratings from One Install to Another

Does not work for me - on the NAS ssh terminal - not sure why - never mind - can I just move com.plexapp.plugins.library.db to the new NAS without doing any harm to keep my old view states?

Thanks
Richard

[ChuckPa]

Richard,

Can you share more info please?

1. From which DSM & App version ? ( Assuming target is DSM 7 PMS )
2. If I gave you a ssh script which automates the work, would that help?

[richard_martin]

Absolutely would help! Thanks

DSM 6.2.4 to DSM 7.1.1 Plex 1.29 to 1.30 is fine. System works well - just the watch history is gone - unless it can grab that from some ‘Plex Cloud’? Lost a disk on the old system - old age for the Sinology - lasted a good close 10 years - some good kit. I have SSH and 1/2 decent SQL skills - python is also installed - the tables just dump empty after the commit.

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;

Thanks
R

[ChuckPa]

What do you have from the old?

I am asking because my tool does it for you.

1. Export the viewstate info to SQL

echo ".dump metadata_item_settings metadata_item_views " | "$PLEX_SQLITE" "$Input" | grep -v TABLE | grep -v INDEX > "$TMPDIR/Viewstate.sql-$TimeStamp"

2. if there are records in the SQL, import it.

    # Import viewstates into working copy
    printf 'Importing Viewstate & History data...'
    "$PLEX_SQLITE" $CPPL.db-$TimeStamp < "$TMPDIR/Viewstate.sql-$TimeStamp" 2> /dev/null