Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
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.
