#!/bin/sh

FILENAME="plexdb_monthly_$(date -u +%FT%T).sqlite"

echo "$(date)"": Starting monthly backup of Plex Database."
if sqlite3 /config/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db ".backup /mnt/media/plexsync/$FILENAME"; then
    echo "$(date)"": Monthly backup of Plex database is complete."
    find /mnt/media/plexsync -name "plexdb_monthly*" | sort | head -n -4 | xargs -I {} rm -- {}
else
    echo "$(date)"": Monthly backup of Plex database has failed."
fi