# DBRepair development

**URL:** <https://forums.plex.tv/t/dbrepair-development/822684>\
**Category:** Apps & Creations\
**Created:** [December 14, 2022, 3:57am UTC](https://forums.plex.tv/t/dbrepair-development/822684 "2022-12-14T03:57:23Z")\
**Posts on this page:** 20\
**Page:** 28

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:26am UTC](https://forums.plex.tv/t/dbrepair-development/822684/595 "2025-03-19T01:26:26Z")

</div>

The correct command sequence, which you only need once.

```auto
tar xf PlexDBRepair-Test.tar.gz
chmod +x DBRepair-Test.sh

```

1. First command extracts everything from the `tar.gz` file
2. Second gives the file ( I only put one file in the tar.gz ) execute permission

and now you can run it.

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 19, 2025, 1:27am UTC](https://forums.plex.tv/t/dbrepair-development/822684/596 "2025-03-19T01:27:30Z")

</div>

Thank you

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:27am UTC](https://forums.plex.tv/t/dbrepair-development/822684/597 "2025-03-19T01:27:42Z")

</div>

this is DBRepair 1.10.03

Please confirm you see 1.10.03 with no errors reported

```auto
#########################################################################
# Plex Media Server database check and repair utility script. #
# Maintainer: ChuckPa #
# Version: v1.10.03 #
# Date: 17-Mar-2025 #
#########################################################################

```

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 19, 2025, 1:33am UTC](https://forums.plex.tv/t/dbrepair-development/822684/598 "2025-03-19T01:33:49Z")

</div>

Osascript e ‘quit app “plex Media Server”’  
cd ~/Downloads  
Tar xvf PlexDBRepair-Test.tar.gz  
cd PlexDBRepair-Test-1.10.03  
Chmod +x DBRepair-Test.sh  
./DBRepair-Test.sh

No it is still showing 1.10.02

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:38am UTC](https://forums.plex.tv/t/dbrepair-development/822684/599 "2025-03-19T01:38:35Z")

</div>

standby. I’ll spin it again

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 19, 2025, 1:38am UTC](https://forums.plex.tv/t/dbrepair-development/822684/600 "2025-03-19T01:38:49Z")

</div>

This is what i have unpacked.

 ![Screenshot 2025-03-19 at 11.37.56 am](https://global.discourse-cdn.com/plex/original/4X/3/d/8/3d8a29b3a69a23f32d93246255201060699f288c.jpeg)

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:41am UTC](https://forums.plex.tv/t/dbrepair-development/822684/601 "2025-03-19T01:41:33Z")

</div>

[DBRepair-Test.tar.gz](https://forums.plex.tv/uploads/short-url/zckkBEeOoHZ6G6coBofH2NtJSuC.gz) (70 KB)

```auto
#!/bin/sh
#########################################################################
# Plex Media Server database check and repair utility script. #
# Maintainer: ChuckPa #
# Version: v1.10.03 #
# Date: 17-Mar-2025 #
#########################################################################

# Version for display purposes
Version="v1.10.03"

# If LC_ALL is null, default to C
["$LC_ALL" = ""] && export LC_ALL=C

```

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:45am UTC](https://forums.plex.tv/t/dbrepair-development/822684/602 "2025-03-19T01:45:16Z")

</div>

Should not see any `RE` errors like you previously showed  
nor any NEW errors 🤣

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:48am UTC](https://forums.plex.tv/t/dbrepair-development/822684/603 "2025-03-19T01:48:14Z")

</div>

@SE56

So you can see what it’s doing, the `v` option in `tar xvf` will print every file it’s eXtracting.

```auto
[chuck@lizum tmp.2014]$ tar xvf DBRepair-Test.tar.gz 
./DBRepair-Test.sh
[chuck@lizum tmp.2015]$

```

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 19, 2025, 1:49am UTC](https://forums.plex.tv/t/dbrepair-development/822684/604 "2025-03-19T01:49:49Z")

</div>

Ok here is what it is like now..

 ![Screenshot 2025-03-19 at 11.47.57 am](https://global.discourse-cdn.com/plex/original/4X/2/b/0/2b0c77256ee71706800639de56fc90570dd8fccb.jpeg)

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:50am UTC](https://forums.plex.tv/t/dbrepair-development/822684/605 "2025-03-19T01:50:24Z")

</div>

Looks good.

OK to publish ?

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 19, 2025, 1:52am UTC](https://forums.plex.tv/t/dbrepair-development/822684/606 "2025-03-19T01:52:52Z")

</div>

Happy camper, awesome Chuck, bit old to do the Toyota celebration. 😎

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 1:57am UTC](https://forums.plex.tv/t/dbrepair-development/822684/607 "2025-03-19T01:57:53Z")

</div>

> **[Release Set LC\_ALL=C when null · ChuckPa/PlexDBRepair](https://github.com/ChuckPa/PlexDBRepair/releases/tag/v1.10.03)**
>
> On certain operating systems (MacOS Sequoia is one), regular expressions used generate errors if LC\_ALL is null.
> This release addresses that problem

---

<div class="post-metadata">

**Author:** ![Kilgry](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@Kilgry](https://forums.plex.tv/u/Kilgry)\
**Post date:** [March 19, 2025, 2:52pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/608 "2025-03-19T14:52:36Z")

</div>

> [@ChuckPa](#):
>
> Also, if they include it, there is a sense of “their version” which they’d be obligated to support.

On the flip side, it currently appears to many of us that your DB tool is _ **supporting** _ “their version” of PMS.

---

<div class="post-metadata">

**Author:** ![ChristianKent](https://avatars.discourse-cdn.com/v4/letter/c/f17d59/32.png) [@ChristianKent](https://forums.plex.tv/u/ChristianKent)\
**Post date:** [March 19, 2025, 8:21pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/609 "2025-03-19T20:21:35Z")

</div>

Thanks so much for adding the command line options. I’ve been using the menu ever since but the whole run takes like 20+ minutes and I’d like it to just do everything in one command, especially starting the server once it’s finished.

```auto
./DBRepair.sh stop auto start exit

```

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 19, 2025, 8:34pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/610 "2025-03-19T20:34:40Z")

</div>

You’re welcome!

They’ve been there for quite a while.

I added it so you could setup a scheduled task / cron job and never worry about it again.

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 22, 2025, 8:13am UTC](https://forums.plex.tv/t/dbrepair-development/822684/611 "2025-03-22T08:13:14Z")

</div>

So to achieve a auto PMS shut down with Terminal with PlexDPRepair. Is this now possible? Presently I need to manually shut down PMS, is my understanding that is what required for 1.10.03 MacOS?

@ChuckPa

Cheers

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 22, 2025, 5:47pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/612 "2025-03-22T17:47:49Z")

</div>

@SE56

on MacOS, it’s been there for quite a while. PMS must be shutdown for the tool to work.

```auto
[chuck@lizum Downloads.2009]$ sudo ../git/chuck/PlexDBRepair/DBRepair.sh stop auto start exit
 
 
 
      Plex Media Server Database Repair Utility (Ubuntu 22.04.5 LTS)
                       Version v1.10.03
 
 
[2025-03-22 13.46.08] Stopping PMS.
[2025-03-22 13.46.08] Stopped PMS.
 
[2025-03-22 13.46.08] Automatic Check,Repair,Index started.
[2025-03-22 13.46.08] 
[2025-03-22 13.46.08] Checking the PMS databases
[2025-03-22 13.46.09] Check complete. PMS main database is OK.
[2025-03-22 13.46.09] Check complete. PMS blobs database is OK.
[2025-03-22 13.46.09] 
[2025-03-22 13.46.09] Exporting current databases using timestamp: 2025-03-22_13.46.08
[2025-03-22 13.46.09] Exporting Main DB
[2025-03-22 13.46.10] Exporting Blobs DB
[2025-03-22 13.46.10] Successfully exported the main and blobs databases.
[2025-03-22 13.46.10] Start importing into new databases.
[2025-03-22 13.46.10] Importing Main DB.
[2025-03-22 13.46.14] Importing Blobs DB.
[2025-03-22 13.46.14] Successfully imported databases.
[2025-03-22 13.46.14] Verifying databases integrity after importing.
[2025-03-22 13.46.15] Verification complete. PMS main database is OK.
[2025-03-22 13.46.15] Verification complete. PMS blobs database is OK.
[2025-03-22 13.46.15] Saving current databases with '-BACKUP-2025-03-22_13.46.08'
[2025-03-22 13.46.15] Making repaired databases active
[2025-03-22 13.46.15] Repair complete. Please check your library settings and contents for completeness.
[2025-03-22 13.46.15] Recommend: Scan Files and Refresh all metadata for each library section.
[2025-03-22 13.46.15] 
[2025-03-22 13.46.15] Backing up of databases
[2025-03-22 13.46.15] Backup current databases with '-BACKUP-2025-03-22_13.46.15' timestamp.
[2025-03-22 13.46.15] Reindexing main database
[2025-03-22 13.46.16] Reindexing main database successful.
[2025-03-22 13.46.16] Reindexing blobs database
[2025-03-22 13.46.16] Reindexing blobs database successful.
[2025-03-22 13.46.16] Reindex complete.
[2025-03-22 13.46.16] Automatic Check, Repair/optimize, & Index successful.
 
[2025-03-22 13.46.16] Starting PMS.
[2025-03-22 13.46.16] Started PMS
 
[chuck@lizum Downloads.2010]$ 

```

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 22, 2025, 6:30pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/613 "2025-03-22T18:30:13Z")

</div>

Oh, so simple. Works an absolute treat 😃

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 22, 2025, 7:08pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/614 "2025-03-22T19:08:26Z")

</div>

I aim to please

🤣

[Previous page](https://forums.plex.tv/t/dbrepair-development/822684.md?page=27)

[Next page](https://forums.plex.tv/t/dbrepair-development/822684.md?page=29)
