Mango 12.4 update to Mango Automation
I’m planning to update Mango version 12.4 for new Mango automation system.
Is it possible to copy Mango's Mysql database with for example Mysql Workbench tool to new system’s Mysql database? I can transfer other settings with import/export function but is that database case possible? If I need to use Mango automation Data import modul what is to practical way to change database to csv -format? I have got 230 data point in my system from two years period, database is quite big. Should I start it from the beginning or can I upload the old data easily?
JoelHaggar last edited by
This is a great question. The data import tool will work but will be a bit time consuming. Do you know how many rows of history data there are for each point; can you export the entire history and view it as csv in excel?
Another option would be to export just the pointValues table from the mysql database and import that into the new MA mysql database, the problem is that dataPointid reference may not match up by default so you would need to go through and make sure they match. I've played around with this awhile ago and it can be a bit difficult to get right.
Look at the dataPoint table in your old version and the the new version and make sure the id matches. I believe that Mango created the data point ID based on the order it is imported so you can rearrange your data points in your import text so that the point ID's are created the same as in your old version.
This is all very theoretical so would like to hear back if any of it works for you.