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.
MySQL database restore
-
Hi, I just start to try using Mango 5 and MySQL. This is the first time I use MySQL at all. I can backup the sql with System -> SQL database backup but when I tried to restore, I got this warning
Even though, the deleted data source was restore but I don't know what may be wrong.
Below is my MySQL config in mango.properties. I doubt my db.mysql is not correct.
db.type=mysql db.url=jdbc:mysql://localhost/mango db.username=root db.password=mangotesting db.mysqldump=C:/Program Files/MySQL/MySQL Server 8.0/bin/mysqldump.exe db.mysql=C:/Program Files/MySQL/MySQL Server 8.0/bin/mysql.exe -
Hi @tungthanh500
Im not exactly sure what you are trying to do. Are you trying to restore an H2 back to a MySQL cause that will not work? You will need to convert the database first. -
Hi @CraigWeb , actually I was trying to install a new Mango 5 instance. Everything is totally new. These are what I did:
1/ Install MySQL 8.0, create a database (scheme) named mango
2/ Install Mango 5 and paste a mango.properties file with MySQL info as above mentioned in mango_data folder.
3/ Start mango service and change admin password.
4/ Create a data source with some data point.
5/ Backup with Backup feature in System Setting -> SQL backup
6/ Delete data source and restore with System Setting -> SQL backup.
7/ See that orange warning pop up, but the deleted data source and data point is back, but I'm not sure if it normal or not.
