This is using it on my main DB
[chuck@glockner ~.2005]$ sudo ./DBRepair-beta.sh stop auto start exit
Plex Media Server Database Repair Utility (Ubuntu 20.04.5 LTS)
Version v1.0.0 - development
[19.36.06] Stopping PMS.
[19.36.06] Stopped PMS.
[19.36.06]
[19.36.06] Checking the PMS databases
[19.36.45] Check complete. PMS main database is OK.
[19.36.45] Check complete. PMS blobs database is OK.
[19.36.45]
[19.36.45] Exporting current databases using timestamp: 2023-02-25_19.36.06
[19.36.45] Exporting Main DB
[19.37.19] Exporting Blobs DB
[19.37.22] Successfully exported the main and blobs databases. Proceeding to import into new databases.
[19.37.22] Importing Main DB.
[19.39.06] Importing Blobs DB.
[19.39.06] Successfully imported data from SQL files.
[19.39.06] Verifying databases integrity after importing.
[19.39.44] Verification complete. PMS main database is OK.
[19.39.44] Verification complete. PMS blobs database is OK.
[19.39.44] Saving current databases with '-BKUP-2023-02-25_19.36.06'
[19.39.44] Making imported databases active
[19.39.44] Import complete. Please check your library settings and contents for completeness.
[19.39.44] Recommend: Scan Files and Refresh all metadata for each library section.
[19.39.44]
[19.39.44] Backing up of databases
[19.39.44] Backup current databases with '-BKUP-2023-02-25_19.39.44' timestamp.
[19.39.45] Reindexing main database
[19.40.57] Reindexing main database successful.
[19.40.57] Reindexing blobs database
[19.40.57] Reindexing blobs database successful.
[19.40.57] Reindex complete.
[19.40.57] Automatic Check,Repair/optimize,Index successful.
[19.40.57] Starting PMS.
[19.40.57] Started PMS
[chuck@glockner ~.2006]$
Got a few cosmetic things to do.
2023-02-25 19.35.45 - ============================================================
2023-02-25 19.35.45 - Session start: Host is Ubuntu 20.04.5 LTS
2023-02-25 19.36.06 - ============================================================
2023-02-25 19.36.06 - Session start: Host is Ubuntu 20.04.5 LTS
2023-02-25 19.36.06 - Stop - PASS
2023-02-25 19.36.45 - Check - Check com.plexapp.plugins.library.db - PASS
2023-02-25 19.36.45 - Check - Check com.plexapp.plugins.library.blobs.db - PASS
2023-02-25 19.36.45 - Check - PASS
2023-02-25 19.37.22 - Repair - Export databases - PASS
2023-02-25 19.39.06 - Repair - Import - PASS
2023-02-25 19.39.44 - Repair - Verify main database - PASS (Size: 1742MB/1680MB).
2023-02-25 19.39.44 - Repair - Verify blobs database - PASS (Size: 1MB/1MB).
2023-02-25 19.39.44 - Repair - Move files - PASS
2023-02-25 19.39.44 - Repair - PASS
2023-02-25 19.39.44 - Repair - PASS
2023-02-25 19.39.45 - Reindex - MakeBackup com.plexapp.plugins.library.db - PASS
2023-02-25 19.39.45 - Reindex - MakeBackup com.plexapp.plugins.library.blobs.db - PASS
2023-02-25 19.39.45 - Reindex - MakeBackup - PASS
2023-02-25 19.40.57 - Reindex - Reindex: com.plexapp.plugins.library.db - PASS
2023-02-25 19.40.57 - Reindex - Reindex: com.plexapp.plugins.library.blobs.db - PASS
2023-02-25 19.40.57 - Reindex - PASS
2023-02-25 19.40.57 - Reindex - PASS
2023-02-25 19.40.57 - Auto - PASS
2023-02-25 19.40.57 - Start - PASS
2023-02-25 19.40.58 - Exit - Delete temp files.
2023-02-25 19.40.58 - Session end.
2023-02-25 19.40.58 - ============================================================
[chuck@glockner Databases.2011]$
