Page 1 of 1

[Solved] Switch from Hsql to Mysql

Posted: Tue Nov 15, 2022 2:22 pm
by StevenK
Installing a new server, and I was about to migrate data but I realised I used hsql in the new install and the old install was mysql.

Is there a way of re-starting the setup?

Re: Switch from Hsql to Mysql

Posted: Tue Nov 15, 2022 3:13 pm
by Vik@Unimus
Yes, the easiest way is to just delete the unimus.properties file at
- Linux - /etc/unimus
- Windows - C:\ProgramData\Unimus
this will "reset" Unimus and trigger the wizard again.

Alternatively, you can just edit relevant properties found in the configuration file above:
- changing database.type from HSQL to MYSQL
- removing the path from database.path
- adding correct information to database.host, database.port, database.name, database.user and database.password.

Also, while that may not be your case, I will mention that don't forget to use the same license key as you used in your original instance as the list of Zones and devices is bound to the current license key and using a different key would result in a loss of those and consequently device data as well (backups, data from ran push jobs, etc).

Re: Switch from Hsql to Mysql

Posted: Tue Nov 15, 2022 3:14 pm
by StevenK
Thanks you !