Hello. I have a sqlt_data.mm.dd.yy tag archive in my MySQL database with a monthly breakdown of 7 years. Each file is 10 gb. Can I upload files from the database in 6 years and then import them back into the database if necessary. Will newly loaded data in the database be displayed in ignition?
You can drop individual partitions, but you must also bookkeep the
sqlth_partitions table at the same time - you’ll notice a record there identifying each of your separate partition tables, along with a start and end timestamp. If those get out of sync, the historian will either not see your restored tables, or error out due to data that’s requested not being present.