Backing up large Historian DB - Ideas?

[richardNZ15]

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.

MySQL Linux Backup Script

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): #----------------------------------------------------------------------------------…