Migrating fixx from the embedded HSQL DB to MySQL
The following steps allow you to migrate the built-in HSQL DB to MySQL.
- Ensure your have upgraded your fixx installation that you
intend to migrate to the latest version.
- Backup your installation to an XML file using the Backup option
in Administration > Backup/Restore
- Ensure you are logged out of fixx and shutdown your fixx
installation.
- IMPORTANT - Backup your entire fixx
installation folder in case anything goes wrong.
- Modify your fixx installation to enable it to connect with
MySQL as described in the
MySQL installation page
- Delete the file fixx-config.properties from
your data folder, which will enable you to run fixx setup
again.
- Start fixx.
- Go through set-up and re-enter your settings. You can re-upload
the existing license file in the data folder of fixx when asked for
a license.
- Once you have fixx set-up, login to it and go to Administration
> Backup/Restore.
- Re-import the XML you exported before and you have successfully migrate to MySQL.
NOTE : If any of the above steps fail, please restore your HSQLDB version of fixx from the backed up zip file and contact your support team.