# 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:** 1\
**Showing post:** 530

<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:** [December 30, 2024, 4:01am UTC](https://forums.plex.tv/t/dbrepair-development/822684/530 "2024-12-30T04:01:19Z")

</div>

## Folks:

One last update to finish the year. 🕶

### DBRepair 1.10.0

- Change Yes/No DB selector to a menu
- Do not check the candidate DBs until after making your selection

It looks like this:

```auto
[chuck@lizum PlexDBRepair.2005]$ sudo ./DBRepair.sh 
 
 
 
      Plex Media Server Database Repair Utility (Ubuntu 22.04.5 LTS)
                       Version v1.10.00
 

Select

  1 - 'stop' - Stop PMS.
  2 - 'automatic' - Check, Repair/Optimize, and Reindex Database in one step.
  3 - 'check' - Perform integrity check of database.
  4 - 'vacuum' - Remove empty space from database without optimizing.
  5 - 'repair' - Repair/Optimize databases.
  6 - 'reindex' - Rebuild database indexes.
  7 - 'start' - Start PMS

  8 - 'import' - Import watch history from another database independent of Plex. (risky).
  9 - 'replace' - Replace current databases with newest usable backup copy (interactive).
 10 - 'show' - Show logfile.
 11 - 'status' - Report status of PMS (run-state and databases).
 12 - 'undo' - Undo last successful command.

 21 - 'prune' - Prune (remove) old image files (jpeg,jpg,png) from PhotoTranscoder cache.
 22 - 'purge' - Purge (remove) all temporary files left by PMS & Transcoder in Temp Dir.
 42 - 'ignore' - Ignore duplicate/constraint errors.

 88 - 'update' - Check for updates.
 99 - 'quit' - Quit immediately. Keep all temporary files.
      'exit' - Exit with cleanup options.

Enter command # -or- command name (4 char min) : Repl
 
Checking the PMS databases
Check complete. PMS main database is OK.
Check complete. PMS blobs database is OK.
Are you sure you want to restore a previous database backup (Y/N) ? y
Checking for a usable backup.
Database backups available are: 2024-11-19 2024-11-01 2024-10-29 2024-10-26
 
  1) - 2024-11-19
  2) - 2024-11-01
  3) - 2024-10-29
  4) - 2024-10-26
 
Select backup date by number or date name (blank = return to menu) 3
Checking backup candidate 2024-10-29
Database backup 2024-10-26 is valid.
 
Use backup dated: '2024-10-29' ? (Y/N) ? y
Saving current databases with timestamp: '-BACKUP-2024-12-29_23.00.36'
Copying backup database from 2024-10-29 to use as new database.
Copy complete. Performing final check
 
Database recovery and verification complete 

```

Thoughts?

[DBRepair-1.10.tar](https://forums.plex.tv/uploads/short-url/u9aIgrU63ErxAyL8sLP31fll6bP.tar) (80 KB)

Line 1234 should be:  
` Output "Database backup $Candidate is valid."`

---

_[View the full topic](https://forums.plex.tv/t/dbrepair-development/822684)._