• Recent
    • Tags
    • Popular
    • Register
    • Login

    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.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Import DB from 2.x to 3.x

    Mango General
    2
    3
    1.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • G
      georgestefan
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • phildunlapP
        phildunlap
        last edited by phildunlap

        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 or Mango/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.

        1 Reply Last reply Reply Quote 1
        • G
          georgestefan
          last edited by

          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!

          1 Reply Last reply Reply Quote 0
          • First post
            Last post