Plex database corrupted - how to fix?

General Discussions
1

hi at all,

plex does not open after a system crash anymore due to corrupted database.

https://support.plex.tv/articles/repair-a-corrupted-database/

I have a backup copy of that specific file “com.plexapp.plugins.library.db”.
can I simply replace it? (see attachment).

best wishes!

plex database
plex database1140×257 145 KB

@OttoKerner I need your help! :slight_smile:

UPDATE: Replacing was not enough, still corrupted. I noticed the database got 4 MB smaller when trying to open plex, so it was modified immediately when starting plex. so it got corrupted trying to open plex. what can I do now?

plex database 2
plex database 2938×316 119 KB

2

Those files with the date in their file names are backup copies as well.
You can drop them into the place of the damaged file.
Make sure to perform the “manual rebuild” procedure on these backups before starting PMS.

And before you do anything at all, check the available free space on drive K:

1 Like
3

for the rebuild procedure I need Plex SQLite tool, right? never done this before.

4

Follow the link above.

5

will do. if nothing works, I could simply delete the plex folder and extract my manual backup from last month? (I zip everything to a file once a month).

6

If you made the copy while Plex server was still running, the database file will be damaged as well.

7

no, I made an offline backup. plex shut down before.
Is a repaired database as reliable as an older copy that was never broken? I would rather just restore from my old backup, but I don’t know which folders/files are necessary.

8

Ideally, you restore the whole plex data folder.
However, if the backup is not too old, you can get away with just restoring the database files: https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/

9

so I first try

  1. repair
    if that does not work you suggest
  2. restoring from a scheduled backup

and if everything fails I can still grab my ZIP-backup, right?

10

Correct.

1 Like
11

took the second approach first since it was easier and it worked just fine.

so plex database is really only those two essential files:

" com.plexapp.plugins.library.db and com.plexapp.plugins.library.blobs.db ." ???

12

No, it’s not that simple.

Perform the repair procedure on those restored files. Otherwise you may be again in the same situation soon.

1 Like
13

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