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.
MangoES covert Database from H2 to mysql?
-
Hi,
I try to convert the database of MangoES from H2 to mysql as online Knowledge base guide of Database Conversions.
http://help.infiniteautomation.com/support/solutions/articles/14000022650-database-conversionsI try to view data in mysql, it have not converted.
Any suggestion?
-
Hi Jenny,
It is important not to perform a conversion at the same time as performing an upgrade.
Beyond that, it could be many things, but posting your logs for a boot attempt could help. Did you log into the mysql shell and create the database? You have to create the database you will be connecting to before launching Mango (not creating any table,s just the database itself).
-
Also, If you are trying to access historical data via MySQL you would need to also uninstall the Mango NoSQL modules. On the MangoES and Enterprise Mango the historical data is stored in the NoSQL database which is separate. Here is a follow up video that explains more: https://help.infiniteautomation.com/support/solutions/articles/14000022517-enterprise-nosql-database
Note that by removing the NoSQL module you will not have access to your existing history. Also the MangoES will lose performance because MySQL is not as efficient at storing and retrieving time series data.
