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.
Restoring H2 Database into Mango V3
-
Hello,
i'm trying to restore a database backup into a new install of Mango V3.
The backup is in two zip files. The points seem to be in one, and the pointdata seems to be in another file (a bunch of numbered folders with .rev files).
The point information restores fine, but none of the historical data is there. Is there another step for that?
Thanks,
ff -
@fishfacs Assuming you have a nosql db there should be nosql export zip files that you use to restore pointvalue data
Fox
-
@MattFox said in Restoring H2 Database into Mango V3:
@fishfacs Assuming you have a nosql db there should be nosql export zip files that you use to restore pointvalue data
Fox
I have a zip file that appears to have the pointvalue data (based on the file size). I just have no idea how to restore it. I don't recognize the file format of the files within the archive. There is no option to restore point data in the GUI. The dropdown only includes the zip files with the configuration and points configuration.
-
@fishfacs you'll need to go to the legacy view to see the mangoNoSql page.
If you don't know how to get there, go via the datasource page via the link highlighted in the information banner across the top. Sorry, am not near my pc right now to take proper screenshots.Fox
-
http://localhost:8080/mango_no_sql.shtm (Or whatever the mango domain is)
That should be the ticket for you
Fox
-
@MattFox said in Restoring H2 Database into Mango V3:
mango_no_sql.shtm
I don't think that works. Your screenshot link is broken, and the path you linked to (mango_no_sql.shtm ) says "Page not found".
I looked through the legacy page (accessed through data sources) but the option to restore sql databases (under settings) only shows the core database file, which includes the points and sources, but not the values.
-
@fishfacs so you don't have noSql then.
There should be a pointvalues table in your h2 db that is populated with data then.Fox
