Thanks. Doing that updated the database. I now see the 'Mom & Dad' account, the kids account I'm guessing is the account with no name, and the Living Room account was one deleted long ago. It's still showing in the database but thats not an issue.
The solution from MovieFan worked just fine. Here were my steps:
Debian# cd /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/
Debian# sqlite3 com.plexapp.plugins.library.db
sqlite> .mode column
sqlite> .header on
sqlite> select id, name from accounts;
id name
1 Administrator
3567592
4494128 Family
4494289 Mom & Dad
sqlite> create table “temp” (“id” INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, “account_id” integer, “guid” varchar(255), “rating” float, “view_offset” integer, “view_count” integer, “last_viewed_at” datetime, “created_at” datetime, “updated_at” datetime, ‘skip_count’ integer DEFAULT 0, ‘last_skipped_at’ datetime DEFAULT NULL, ‘changed_at’ integer(8) default ‘0’);
sqlite> insert into temp select * from metadata_item_settings where account_id = 1;
sqlite> update temp set account_id = 4494128;
sqlite> insert into metadata_item_settings (account_id, guid, rating, view_offset, view_count, last_viewed_at, created_at, updated_at, skip_count, last_skipped_at, changed_at) SELECT account_id, guid, rating, view_offset, view_count, last_viewed_at, created_at, updated_at, skip_count, last_skipped_at, changed_at from temp;
sqlite> drop table temp;
Thanks for the help.
