It’s a tool I wrote which , if at all possible, will repair your database so you can get back to using Plex without needing to start from scratch.
Up for it?
It’s a tool I wrote which , if at all possible, will repair your database so you can get back to using Plex without needing to start from scratch.
Up for it?
I guess. I got nothing to lose.
Here we go. If you have any questions along the way. ask.
I’ll go part way then stop and check on your progress
/plex_service.sh -d
cd /MOVIES
tar xf DBRepair.tar
chmod +x DBRepair.sh
./DBRepair.sh
You should see:
root@dockerplex:/# chmod +x DBRepair.sh
root@dockerplex:/# ./DBRepair.sh
Plex Media Server Database Repair Utility (Docker)
Select
1. Check database
2. Vacuum database
3. Reindex database
4. Attempt database repair
5. Replace current database with newest usable backup copy
6. Undo last successful action (Vacuum, Reindex, Repair, or Replace)
7. Import Viewstate / Watch history from another PMS database
8. Show logfile
9. Exit
Enter choice:
Sooooo…what do I do? How do I use it?
oh. sorry. sent that before you did
Let me know when you have the menu showing
Do I hit enter after each line or type them all out first?
Enter after each line. Each is an individual command
I should have numbered them… sorry
Got it!
Ready
YES!!!
We’re going to run the sequence (1 , 4 , 3)
1 == Confirm the DB damage is seen by the tool (how bad)
4 == Attempt repair (reconstruct the database)
3 == Rebuild all the indexes which PMS will need.
Ok. I did number 1
Checking the PMS databases
Check complete. PMS main database is damaged.
Check complete. PMS blobs database is OK.
Excellent…
Now option 4…
Let it do the repair.
Should I continue?
typed as soon as I got your results ![]()
Typing in advance.
It will EXPORT then IMPORT then CHECK the database to confirm it rebuilt OK.
It will do this for Main and Blobs.
If both are OK, it will make them the active databases
Wow. Ok. It just gave me alot.
screenshot
I screenshoted but I’m afraid if I navigate away, the console will close.
If you switch browser tabs, everything will stay.
You can open a new browser window too if you want.