# Restore Managed Users? **URL:** \ **Category:** General Discussions\ **Tags:** managed-accounts\ **Created:** [April 26, 2020, 8:46pm UTC](https://forums.plex.tv/t/restore-managed-users/581312 "2020-04-26T20:46:03Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![emrys](https://avatars.discourse-cdn.com/v4/letter/e/4491bb/32.png) [@emrys](https://forums.plex.tv/u/emrys)\ **Post date:** [April 26, 2020, 8:46pm UTC](https://forums.plex.tv/t/restore-managed-users/581312/1 "2020-04-26T20:46:04Z")
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!! ---
**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\ **Post date:** [April 26, 2020, 9:07pm UTC](https://forums.plex.tv/t/restore-managed-users/581312/2 "2020-04-26T21:07:25Z")
You don’t need to delete your old account… just leave their home > **[How do I leave a Plex Home? | Plex Support](https://support.plex.tv/articles/203888038-how-do-i-leave-a-plex-home/)** > > Leaving a Plex Home is easy to do. However, make sure you really want to do so as there could... # **Edit:** You cannot recreate managed users and their profiles from one account to another. ---
**Author:** ![emrys](https://avatars.discourse-cdn.com/v4/letter/e/4491bb/32.png) [@emrys](https://forums.plex.tv/u/emrys)\ **Post date:** [April 26, 2020, 9:16pm UTC](https://forums.plex.tv/t/restore-managed-users/581312/3 "2020-04-26T21:16:34Z")
Thanks Tom - unfortunately the managed user has been deleted. If I restore a database backup, will that restore the history of that user? ---
**Author:** ![emrys](https://avatars.discourse-cdn.com/v4/letter/e/4491bb/32.png) [@emrys](https://forums.plex.tv/u/emrys)\ **Post date:** [April 29, 2020, 9:21am UTC](https://forums.plex.tv/t/restore-managed-users/581312/4 "2020-04-29T09:21:57Z")
Hi Tom - is there any other way to restore the watched history of the deleted user? ---
**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\ **Post date:** [April 29, 2020, 9:33am UTC](https://forums.plex.tv/t/restore-managed-users/581312/5 "2020-04-29T09:33:05Z")
Nothing that I’m aware of ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [April 29, 2020, 10:53am UTC](https://forums.plex.tv/t/restore-managed-users/581312/6 "2020-04-29T10:53:39Z")
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_id`s 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. ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [July 28, 2020, 10:53am UTC](https://forums.plex.tv/t/restore-managed-users/581312/7 "2020-07-28T10:53:44Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.