DBRepair development

Dev Community Apps & Creations
530

Folks:

One last update to finish the year. :sunglasses:

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:

[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 (80 KB)

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

4 Likes