• 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

    H2 database upload

    User help
    2
    4
    2.2k
    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.
    • B
      bryanh
      last edited by

      The H2 database is backuped up as a zip file. When the file is unzipped it becomes a SQL file. My question is how do I reupload that database into Mango?

      I have an idea, let me know if I am on the right track:

      Open the SQL file in Notepad
      Save as a json file
      Open import/export in Mango
      Copy json text into Mango
      Import

      1 Reply Last reply Reply Quote 0
      • JoelHaggarJ
        JoelHaggar
        last edited by

        The easiest way is on the system setting page under Database Backup Settings:

        upload-90d21e69-af6f-4ae4-bd86-5d76406ebd4e

        Click the Get backups button and this will populate the dropdown list of available backups to restore.

        1 Reply Last reply Reply Quote 0
        • B
          bryanh
          last edited by

          Thanks, Joel.

          Will this also work with the NoSQL database?

          1 Reply Last reply Reply Quote 0
          • JoelHaggarJ
            JoelHaggar
            last edited by

            No, that's only for the H2 database but there is a similar tool for NoSQL depending on what version you have. Its on the NoSQL tab on the main menu but I think this is only in 2.6. You can just unzip the NoSQL database and copy it into the databases folder to replace what is there.

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