How to restore QNAP P:lex from backup

[dmoor]

Server Version#: 1.16.1 (as installed from QNAP store)
Player Version#:

I am trying to restore my Plex server from backup to my QNAP TS-453bt3. I wiped the [/share/CACHEDEV1_DATA/.qpkg/PlexMediaServer/Library/Plex Media Server

directory and restored it from backup. The initial startup failed as the IP address of the server had changed. I changed the IP address of the QNAP to the address that Plex was trying to use and now I get the error in the Plex server log (this is the entire log):

Mar 08, 2020 02:15:30.717 [0x7f178bc76700] INFO - Plex Media Server v1.16.6.1592-b9d49bdb7 - QNAP TS-453BT3 x86_64 - build: linux-x86_64 qnap - GMT -11:00

Mar 08, 2020 02:15:30.718 [0x7f178bc76700] INFO - Linux version: QTS 4.4.1.1216, language: en-US

Mar 08, 2020 02:15:30.718 [0x7f178bc76700] INFO - Processor Intel® Celeron® CPU J3455 @ 1.50GHz

Mar 08, 2020 02:15:30.718 [0x7f178bc76700] INFO - ./Plex Media Server

Mar 08, 2020 02:15:30.662 [0x7f179551b740] DEBUG - BPQ: [Idle] -> [Starting]

Mar 08, 2020 02:15:30.682 [0x7f179551b740] DEBUG - FeatureManager: Using cached data for features list

Mar 08, 2020 02:15:30.724 [0x7f179551b740] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.26.0, threadsafe=1

Mar 08, 2020 02:15:30.728 [0x7f179551b740] INFO - SQLITE3:(nil), 283, recovered 930 frames from WAL file /share/CACHEDEV1_DATA/.qpkg/PlexMediaServer/Library/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db-wal

Mar 08, 2020 02:15:30.728 [0x7f179551b740] ERROR - SQLITE3:(nil), 11, database corruption at line 66053 of [bf8c1b2b7a]

Mar 08, 2020 02:15:30.728 [0x7f179551b740] ERROR - SQLITE3:(nil), 11, database disk image is malformed in “PRAGMA cache_size=2000”

Mar 08, 2020 02:15:30.795 [0x7f179551b740] ERROR - Database corruption: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2000

Mar 08, 2020 02:15:30.795 [0x7f179551b740] ERROR - Error: Unable to set up server: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2000 (N4soci10soci_errorE)

So the immediate questions are:

1. If the server is looking for the wrong IP address, is there a configuration file I can edit to change it?

2. How do I get rid of the database corruption error?

Thanks!

[dane22]

Database is currupted!

See if you also backed up the backups, and if so restore the latest of them

Restore a Database Backed Up via 'Scheduled Tasks' | Plex Support

[dmoor]

Went though multiple backups until I found one that worked. Weird thing is that the “backup” I was using was the original data. I had renamed it PlexMediaServerBackup, reinstalled Plex then copied it back to the new PlexMediaServer directory.

Thanks!