# Corrupt Database - Transferring User Information **URL:** \ **Category:** Plex Media Server\ **Tags:** server-windows\ **Created:** [January 16, 2022, 10:42pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222 "2022-01-16T22:42:12Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 16, 2022, 10:42pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/1 "2022-01-16T22:42:12Z")
Server Version#:1.24.4.5081 Player Version#:1:24.4.5081 Hi there: I’m hoping someone can help me. I’ve got a corrupted database on Windows 10 and have been unable to update since version 1.24.4.5081. If I update none of my files will play including on my computer so I have to do a roll back. I’m not worried about my database, but I do want to transfer my user data and viewing information. I’ve tried repairing my database with no luck and have followed the directions in the article - Move Viewstate/Ratings from One Install to Another but get an error message. ‘sqlite3’ is not recognized as an internal or external command, operable program or batch file. I don’t know anything about sqlite3. If anyone has any advice, I would appreciate it. Thank you! ---
**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:** [January 16, 2022, 11:04pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/2 "2022-01-16T23:04:06Z")
Check out the instructions from repairing the corrupt database; you’ll need to use the bundled version of `Plex SQLite` for this job. Though don’t get your hopes too high… if the database is toast your chances of pulling anything out aren’t necessarily good. ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 18, 2022, 12:38am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/3 "2022-01-18T00:38:22Z")
How do you run the Plex SQlite bundled version? I can’t find it anywhere. I’ve tried the windows command prompts in that article before with no luck but don’t know anything about using or finding Plex SQlite. 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:** [January 18, 2022, 7:48am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/4 "2022-01-18T07:48:23Z")
It should be in the Plex Media Server app folder on your C:\ drive (program files) ---
**Author:** ![Bailey2013](https://avatars.discourse-cdn.com/v4/letter/b/b3f665/32.png) [@Bailey2013](https://forums.plex.tv/u/Bailey2013)\ **Post date:** [January 18, 2022, 3:06pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/5 "2022-01-18T15:06:53Z")
Do you know what the program/file is called that I am looking for? I have no idea what I’m looking for. Thanks again! ---
**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:** [January 18, 2022, 3:17pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/6 "2022-01-18T15:17:17Z")
The file is called `Plex SQLite.exe` and it’s stored alongside the Plex Media Server executable in your system’s app folder (usually `C:\Program Files\Plex\Plex Media Server\`, possibly `C:\Program Files (x86)\…`) ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 20, 2022, 2:05am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/7 "2022-01-20T02:05:38Z")
Perfect, thanks I’ve found it. ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 21, 2022, 11:26pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/8 "2022-01-21T23:26:35Z")
Sadly when I tried using sqlite all I get is the following ![IMG_3327](https://global.discourse-cdn.com/plex/original/4X/2/2/2/2227c6e86ad36746031abb5b4de6d17d24f175b4.jpeg) ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [January 21, 2022, 11:49pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/9 "2022-01-21T23:49:04Z")
You ran the file first, which you don’t need to do. You just need to open a regular command prompt window. Enter the command there. Please read the support article carefully. If you randomly start typing command, you risk further damaging your database. If you are not familiar with SQLite, it may be better to check if you have database backups and just replace the current com.plexapp.plugins.library.db file with a backup. ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 22, 2022, 12:11am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/10 "2022-01-22T00:11:38Z")
I tried using CMD originally and got the following which is why I thought maybe I needed to do something with SQLite ![image0 (1)](https://global.discourse-cdn.com/plex/original/4X/1/9/3/193793244af244ce9a078f71579ee7d405c59ae8.jpeg) ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [January 22, 2022, 12:39am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/11 "2022-01-22T00:39:17Z")
That is correct. There is no output when running the command. As long as you don’t get an error, it ran and finished. No is no need to do anything else. Just run PMS and see if it’s fixed. If not, then the recovery did not result in a valid file. You will need to use a database backup if you have one or start over. ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 22, 2022, 3:06am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/12 "2022-01-22T03:06:16Z")
Thank you. I guess my next question is as I said at the top is I’m less worried about my database, than keeping my user data and viewing information. Does this process do that? Or is there something else I need to do. Thank you again for your help. I really appreciate it. ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [January 22, 2022, 6:17am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/13 "2022-01-22T06:17:27Z")
The played history is stored in this database. If the repair works, then whatever play history will get saved too. If this doesn’t work and you have a good (not corrupted) backup database, restoring that database will bring back your play history up to the date of that backup. ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 22, 2022, 2:27pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/14 "2022-01-22T14:27:55Z")
Unfortunately that didn’t fix my backup so my next question is. Is there a way to create a new uncorrupted database in a different area so that I can then delete the old database and replace it with the new one? thanks again ---
**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:** [January 22, 2022, 4:12pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/15 "2022-01-22T16:12:18Z")
If you’re going to nuke your setup in order to start over, simply delete the content of your Plex Media Server’s data directory (+ some of the registry information). When you start your server it should offer you to setup a new server / libraries / … > **[Restart Plex Media Server Setup from Scratch | Plex Support](https://support.plex.tv/articles/201198426-restart-plex-media-server-setup-from-scratch/)** > > In some cases, you may decide that you wish to restart your setup on your Plex Media Server from scratch.... ---
**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\ **Post date:** [January 22, 2022, 5:28pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/16 "2022-01-22T17:28:21Z")
This doc also might be of help if you are starting over … > **[Move Viewstate/Ratings from One Install to Another | Plex Support](https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/)** > > The watched/unwatched, view progress, and ratings are stored in an install-independent fashion that makes them easy to move between installations... It won’t restore your watch history but will restore your view state history. I’m unaware of anyway keep dashboard watch history but this certainly works for view state as I’ve used the steps myself. ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 22, 2022, 5:52pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/17 "2022-01-22T17:52:32Z")
Thanks I’ll definitely look into it. I have another hard drive set up already so will take a peak at the articles above. thanks again everyone! ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [January 22, 2022, 6:21pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/18 "2022-01-22T18:21:01Z")
I thought you already read that article. You mentioned it in your original post. ---
**Author:** ![Bailey2013](https://avatars.discourse-cdn.com/v4/letter/b/b3f665/32.png) [@Bailey2013](https://forums.plex.tv/u/Bailey2013)\ **Post date:** [January 22, 2022, 6:48pm UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/19 "2022-01-22T18:48:30Z")
Yes I have read both the articles. I didn’t take the time to look at the article names as I was running out the door and was just saying thanks for the responses. Thanks again ---
**Author:** ![Grappler1](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@Grappler1](https://forums.plex.tv/u/Grappler1)\ **Post date:** [January 23, 2022, 12:26am UTC](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222/20 "2022-01-23T00:26:04Z")
Might be another dumb question but if I’m attempting to restore from a back up, does the library.db file and library.blobs file have to be the same date? Only reason I’m asking is that in my folder I don’t have two that match dates. thanks [Next page](https://forums.plex.tv/t/corrupt-database-transferring-user-information/771222.md?page=2)