web stats
Skip to end of metadata
Go to start of metadata

Mirth Connect ships by default using the Apache Derby database. You may find yourself in a situation where you wish to move the Mirth Connect database to MySQL / PostgreSQL / Oracle / SQL Server, but you do not want to lose your configuration settings. This page will give you a step-by-step guide to backing up your existing Mirth Connect database, changing the database configuration entry in Mirth Connect, as well as re-importing your configuration after.

Step-by-step guide

  1. Log into your existing Mirth Connect Administrator
  2. Click Settings on the left hand navigation menu under the Mirth Connect heading.
  3. Click the Backup Config link under the Server Tasks heading.
  4. Specify a location to save the backup XML file and press Save.
  5. Locate your mirth.properties configuration file and open it in your favorite text editor.
  6. Modify the existing database configuration entry, replacing the existing value with one of the allowed values (derby, mysql, oracle, postgres, sqlserver)
    1. Example: database = mysql
  7. Modify the database.url configuration entry, replacing the existing value with the jdbc protocol address of your server (Depending on your database environment, you may need to create the database first)
    1. Example: database.url = jdbc:mysql://localhost:3306/mirthdb
  8. Modify the database.username and database.password configuration entries, specifying the credentials needed to connect to your target database.
    1. Example: database.username = jimi
    2. Example: database.password = MirthIsCool
  9. Save the file
  10. Restart Mirth Connect server
  11. If everything is successful, Mirth Connect should restart and be pointed to your new database. If not, review the error logs and correct any issues.
  12. Reconnect to the Mirth Connect Administrator
  13. Login with the default credentials of admin / admin
  14. Create a new user and fill out the new user dialog form and save the user.
  15. Click on the Settings option under the Mirth Connect navigation heading.
  16. Click on the Restore Config option under the Server Tasks navigation heading.
  17. Browse to the file that you exported earlier and click Open.
  18. If everything is successful, all of your configuration settings, alerts, and channels should be imported