Restore Managed Users?

General Discussions
1

Hi there,

This may be an often asked question but Im hoping there’s an answer: is it possible to restore a deleted user profile? I made the rookie mistake of joining another persons Home on their invitation, and was only able to recover by deleting my previous profile. I had created a managed home user, and would like to recreate the viewing / listening history / profile.

Any tips gratefully received…

Thanks!!

1 Like
2

You don’t need to delete your old account… just leave their home

Edit:
You cannot recreate managed users and their profiles from one account to another.

3

Thanks Tom - unfortunately the managed user has been deleted. If I restore a database backup, will that restore the history of that user?

1 Like
4

Hi Tom - is there any other way to restore the watched history of the deleted user?

5

Nothing that I’m aware of

6

The following can damage your database and make it unusable!

Please don’t attempt it if you don’t have any SQL experience and if you don’t have a backup copy of your database. (It is easy enough to fetch one, directly under Settings - Manage - Troubleshooting)

Theoretically, there is a way to edit the plex SQLite database directly, and change all account_id references (which are currently pointing to the user ID of the old managed user) to that ID of the new managed user.
But still I have to hear back for confirmation, if this is viable.

If you know SQL, you can do this relatively easy.
First, you determine the account_ids of the old and the new managed user, by inspecting the table accounts. The number is in the column ID.

Of main interest are the tables metadata_items_accounts and metadata_items_settings
(These affect the statistics and the ‘played’ items of the user.)
but there are still 10 other tables wtih a column account_id
The idea is to change all user_id values from the old managed user to that of the new managed user.
I still have to determine which ones are safe to edit and which ones are not.
So if it’s not terribly urgent, you’d rather wait a few hours.

1 Like
7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.