[Solved] Switch from Hsql to Mysql

Unimus support forum
Post Reply
StevenK
Posts: 13
Joined: Wed Nov 15, 2017 2:37 pm

Tue Nov 15, 2022 2:22 pm

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?
Vik@Unimus
Posts: 198
Joined: Thu Aug 05, 2021 6:35 pm

Tue Nov 15, 2022 3:13 pm

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).
StevenK
Posts: 13
Joined: Wed Nov 15, 2017 2:37 pm

Tue Nov 15, 2022 3:14 pm

Thanks you !
Post Reply