• header.categories
    • header.recent
    • header.tags
    • header.popular
    • register
    • login

    MYSQL Workbench

    scheduled pinned locked moved General Discussion
    10 posts 2 posters 4.7k views 1 watching
    loading-more-posts
    • oldest-to-newest
    • newest-to-oldest
    • most-votes
    reply
    • reply-as-topic
    guest-login-reply
    deleted-message
    • C offline
      cjm4909
      global:last-edited-by,

      Can you use MySQL Workbench to access/update the H2DB database? Some of my sensors have stored incorrect (out of range) data and I want to clean it up so the graph is displayed correctly again?

      Thanks

      jkandasaJ one-reply-to-this-post last-reply-time reply quote 0
      • jkandasaJ offline
        jkandasa @cjm4909
        global:last-edited-by,

        @cjm4909 You cannot use MySQL workbench to access H2 database, However you can use H2 db utilities to access H2 database.
        To access via command line follow this: http://forum.mycontroller.org/topic/18/forgotten-password/2

        To access on browser: just run java -cp h2/bin/h2*.jar command once you downloaded http://www.h2database.com/h2-2014-04-05.zip.

        IMPORTANT: MyController server should be stopped when you access H2 database

        one-reply-to-this-post last-reply-time reply quote 0
        • C offline
          cjm4909
          global:last-edited-by,

          @jkandasa said:

          @cjm4909 You cannot use MySQL workbench to access H2 database, However you can use H2 db utilities to access H2 database.
          To access via command line follow this: http://forum.mycontroller.org/topic/18/forgotten-password/2

          To access on browser: just run java -cp h2/bin/h2*.jar command once you downloaded http://www.h2database.com/h2-2014-04-05.zip.

          IMPORTANT: MyController server should be stopped when you access H2 database

          Thank you

          one-reply-to-this-post last-reply-time reply quote 0
          • C offline
            cjm4909
            global:last-edited-by,

            I was able to connect via the browser, what table/tables would hold the sensor data?

            jkandasaJ one-reply-to-this-post last-reply-time reply quote 0
            • jkandasaJ offline
              jkandasa @cjm4909
              global:last-edited-by,

              @cjm4909 If you are looking sensor, then should be sensor
              If you are looking sensor variable, then should be sensor_variable

              Please note: Some internal mapping will be added for each resources on DB. Which is not a good approach to clean from database. What is the exact issue are you facing?

              C one-reply-to-this-post last-reply-time reply quote 0
              • C offline
                cjm4909 @jkandasa
                global:last-edited-by,

                @jkandasa no real issue, I just have a few temp sensors that produce an incorrect value sometimes (3434430.00 F) and I would like to remove those values from the data.

                jkandasaJ one-reply-to-this-post last-reply-time reply quote 0
                • jkandasaJ offline
                  jkandasa @cjm4909
                  global:last-edited-by,

                  @cjm4909 You can remove this value from GUI, Yes, in recent build(SNAPSHOT) build we have an option on sensorVariable

                  Navigate to Resources >> Sensors >> Detailed view of your sensor, click on purge icon,
                  0_1480001122380_upload-6e5ee459-e643-4777-83ca-87e95409e3c1

                  Now select value range and time range(if required).
                  0_1480001233595_upload-7142d40f-74e2-4a3f-9715-764d78660eda

                  NOTE: If you leave all the fields blank, will delete everything(metrics).

                  You can remove it from database table also, check it on the table metrics_double_type_device and remove it

                  one-reply-to-this-post last-reply-time reply quote 0
                  • C offline
                    cjm4909
                    global:last-edited-by, cjm4909

                    Thank you, I assume the most recent build isn't out yet. I am on 0.0.3.Alpha2.

                    jkandasaJ one-reply-to-this-post last-reply-time reply quote 0
                    • jkandasaJ offline
                      jkandasa @cjm4909
                      global:last-edited-by,

                      @cjm4909 Yes, however you can download SNAPSHOT build from http://forum.mycontroller.org/topic/58/download-snapshot-build

                      C one-reply-to-this-post last-reply-time reply quote 0
                      • C offline
                        cjm4909 @jkandasa
                        global:last-edited-by,

                        @jkandasa The purge in the Snapshot is working great.

                        one-reply-to-this-post last-reply-time reply quote 1
                        • first-post
                          last-post

                        0

                        online

                        644

                        users

                        532

                        topics

                        3.4k

                        posts
                        Copyright © 2015-2025 MyController.org | Contributors | Localization