# Issue with MySQL and Ignition **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [September 19, 2024, 9:04am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171 "2024-09-19T09:04:39Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Filippos\_Onisiforou](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/filippos_onisiforou/32/68090_2.png) [@Filippos\_Onisiforou](https://forum.inductiveautomation.com/u/Filippos_Onisiforou)\ **Post date:** [September 19, 2024, 9:04am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/1 "2024-09-19T09:04:39Z")
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. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [September 19, 2024, 9:14am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/2 "2024-09-19T09:14:40Z")
> [@Filippos\_Onisiforou](#): > > PowerGraph Power Chart? How are you inspecting the database? > **[Ignition Database Table Reference | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/appendix/reference-pages/ignition-database-table-reference#sqlth_1_data)** > > Ignition has a lot of systems built-in that will query the database automatically without requiring you to build a query. These systems automatically create the necessary tables in the database, insert the relevant data, and even query it back out... ---
**Author:** ![Filippos\_Onisiforou](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/filippos_onisiforou/32/68090_2.png) [@Filippos\_Onisiforou](https://forum.inductiveautomation.com/u/Filippos_Onisiforou)\ **Post date:** [September 19, 2024, 9:38am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/3 "2024-09-19T09:38:34Z")
yes sorry i meant power Chart. How can i check if data are flowing to my database? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/5/f5857b6c13baca9d6bd54b370dea857329d147df.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [September 19, 2024, 11:48am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/4 "2024-09-19T11:48:41Z")
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. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [September 19, 2024, 11:50am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/5 "2024-09-19T11:50:35Z")
> [@Filippos\_Onisiforou](#): > > But if i use the tags for the PowerGraph i can see the historical values on the graph. If there are no values in your database, then what values are being shown on the Power Chart? The Power Chart only works with the Tag Historian, so you must have a Tag with history configured and your database set as the Provider. ---
**Author:** ![Filippos\_Onisiforou](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/filippos_onisiforou/32/68090_2.png) [@Filippos\_Onisiforou](https://forum.inductiveautomation.com/u/Filippos_Onisiforou)\ **Post date:** [September 19, 2024, 11:54am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/6 "2024-09-19T11:54:54Z")
Hi Irose see below screenshot ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/1/f1a314166deee2eb78696a632f3bdb89feae8a53.png) 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. ---
**Author:** ![Filippos\_Onisiforou](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/filippos_onisiforou/32/68090_2.png) [@Filippos\_Onisiforou](https://forum.inductiveautomation.com/u/Filippos_Onisiforou)\ **Post date:** [September 19, 2024, 11:59am UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/7 "2024-09-19T11:59:14Z")
Hi Transistor this i what i see now ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/edc4f638dc77e47b0770d2b3c8e1bf9a77781d95.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [September 19, 2024, 1:00pm UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/8 "2024-09-19T13:00:11Z")
Try this in the Query text field: ```python SELECT * FROM sqt_data_1_2024_09 ``` Then open the Testing tab and hit the Execute Query button. If you want to get fancy then do a join on the sqlth\_te table to retrieve the tagpath. ---
**Author:** ![Filippos\_Onisiforou](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/filippos_onisiforou/32/68090_2.png) [@Filippos\_Onisiforou](https://forum.inductiveautomation.com/u/Filippos_Onisiforou)\ **Post date:** [September 19, 2024, 1:24pm UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/9 "2024-09-19T13:24:28Z")
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 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/8/48f7b5321e7740672b9367afcc442579d2098c08.png) 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. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [September 19, 2024, 1:27pm UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/10 "2024-09-19T13:27:29Z")
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. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [September 19, 2024, 1:31pm UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171/11 "2024-09-19T13:31:23Z")
Have a read through the following articles. > **[How the Tag Historian System Works | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/tag-historian/how-the-tag-historian-system-works)** > > This page provides an overview on how the Tag Historian system evaluates tag changes, stores them, and later retrieves those values. > **[Configuring Tag History | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/tag-historian/configuring-tag-history)** > > In 8.1.17, the Tag Editor was redesigned to improve usability. The new Tag Editor now requires fewer clicks and keeps relevant tag information visible while modifying bindings, alarms, and event scripts. Pay particular attention to the data compression methods.