Hello Guys, i have a problem with Mysql and Ignition . Although it seems that Ignition Located the Mysql Database ,nothing are store in the database. I saw the video provided by ingition but i have not seen any example of it actual working.
I have created a database with MYSQL i have established the connection between Ignition and the database but still have no values stored in the Database. But if i use the tags for the PowerGraph i can see the historical values on the graph.
Can someone guide me please through it ? My experience with the databases are limited.
Thanks in advance.
If you don't have a database development then you can use the named query editor. Select the Authoring tab, select the database from the dropdown and browse the tasks and columns on the right.
I dont know who to map my database so it will be regognize where the values should be store. With SQlite it was much easier to set it and store the Values. Mysql is different.
With SQlite you set the database , the device name for example and the values as tags which you want to record.
I found this and yes i have data inside this table. But i want to have for example 30 values stored with the date and time. how can i do that? this is storing only one value atm and i have configured in ingition 6 tags for testing . and only one tag is stored
i thought i could create the tables by myself and only the name should match to be able to store the values. Do you have any example to show me ?
im currently using Mysql workbench and Dbeaver to check the values.
All you need to do is configure a tag with history, and set the history provider. In your example the only option that you will have available is ‘IgnitionDB’.
Once you have a tag, the historian will take care of creating the proper tables for you and start recording values into the data table.
