Merging a database backup with new information
We have an installation where we accidentally erased one of our datapoints. We thought we could upload the last backup to get the old data, but is there a way we could be able to merge with the latest data that we have been collecting or at least not overwrite the latest data. So in essence we could have all the data we've been collecting as if we had never erased it int eh first place.
Or... is there an easier way to grab just the data from the point we erased and add it back to our database.
When you delete a data point in Mango the history will be deleted on the next nightly purge so it's important to resolve the situation before that happens.
I'll assume you are using the H2 data for your configuration and the NoSQL for the history. On the system setting page you should see the option to restore the H2 database from a backup. Click the "Get Backups" button to load in a list of available backups. Select the one you want and then click the Restore database button. If the database you restore has the deleted data point in it then all should be back to normal and your data should still be available for the data point.