To anyone finding this post, i found this other post which details how to execute a script to backup the Historian database, excluding the latest created partition.
I’ve written the following script to backup the last closed historical partition and assosiated data tables for the Ignition historian on Linux. You can schedule this with cron tab and store the backups on a remote windows share or something pretty easily.
#!/usr/bin/python
import sys
import os
import datetime
import mysql.connector
from subprocess import call
from optparse import OptionParser
def main(argv):
#----------------------------------------------------------------------------------…