First identify the id numbers for the accounts involved.
SELECT id, name FROM accounts;
Create a temporary blank copy of the table. I call it temp.
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);
Copy over the info for the source user. I used the admin.
INSERT INTO temp SELECT * FROM metadata_item_settings WHERE account_id = 1;
Change the id to the new user.
UPDATE temp SET account_id = 101010;
Copy this new info back to the original table.
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) SELECT account_id, guid, rating, view_offset, view_count, last_viewed_at, created_at, updated_at, skip_count, last_skipped_at FROM temp;
Delete the temp table.
DROP TABLE temp;
Done.
