Server Version#: current Public on QNAP (latest QTS firmware)
Player Version#: N/A
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>
Hi
Long time lifetime pass PLEX user who has lost a number of databases over the years and never fully been happy with the backup functionality of PLEX/QNAP e,g. PLEX needs to fully stop for a db copy to be successfully made.
Does the “Download Database” capability actually provide an exportable/importable db backup?
Unzipping the file produces one large file that doesn’t match the three day rolling internal backups being made (by name, size or file extension). So, it can’t be re-imported into PLEX?
What am I missing in terms of QNAP backup of PLEX?
Now got again to a stable state yet remain in dread of losing 2yrs work in a corrupt db and an inability to load in a backup. Seems simple stuff to me in theory. Why in PLEX on a QNAP is it a nightmare?
And don’t get me onto exporting/importing basic playlists…
The file is a copy of the DB file, you could load it in sqlite to create export sql or use it as a backup and replace the db file but you don’t get the blobs.
It would be better to focus on the 3 day backups that give you the db and blobs-db file in sync. Either turn on backup notifications or watch the directory for backups. If at anytime the 3 day backup doesn’t occur use the last backups to replace your blobs and db.
On QNAP, because of how QPKG works, we have a bit of an odd-ball access to the metadata but it’s stable and works perfectly via FIleStation once you understand how it works.
Tiebierius - thank you for answering my specific question and flagging the 3day backup and Chuck Pa’s work with the very sensible proviso of familiarity before loss. Indeed :). Notification of when this has stopped working is the key for prompt remedial action. “backup notifications” - wouldn’t that be good if it came from PLEX itself as don’t seem to have found that function.
Chuck Pa - thank you for picking up on this and making sure I do read the Read Me First. I will get my head around all this for the given reasons. Grateful there are those writing such tools.
