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.
Import DB from 2.x to 3.x
-
Hello, I tried to import a data base from a 2.x Mango to a 3.x Mango, the data base was imported with all the points but the values for those points are not imported. I have a backup and I restore database from System Settings, after a reboot the mango crashes and in order to make it to work again I have to delete the mah2.h2.db
-
Hi georgestefan,
If you are using NoSQL, your values are not in your SQL database. If you are using SQL for point values, there is no reason an upgrade would prevent you from seeing the point values, especially if you're booted to the point you can see the data points. It's possible something in the table formation went wrong. You should consult your
Mango/logs/ma.log
orMango/bin/logs/ma.log
file for errors and post them. If you are creating the DB from a SQL backup you cannot restore a 2.8 backup into a 3.x system. You must restore the backup into a 2.8 system, then copy the mah2.h2.db file into the new Mango/databases directory. Your point values are probably in your 2.8 Mango/databases/mangoTSDB directory, which should be copied to the 3.x instance as well. -
I've copied mah2.h2.db and the other two files and than I've restored my NoSQL backup to mangoTSDB folder and worked perfect.
Thanks!