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
phildunlap last edited by phildunlap
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/bin/logs/ma.logfile 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.