Uptime Infrastructure Monitor uses MySQL as its default DataStore although MS SQL Server and Oracle are also supported. Please see Supported Databases in Uptime Infrastructure Monitor for details on supported versions.

If you plan to change your DataStore to another supported database, you will need to:

Backup and Restore the DataStore

Uptime Infrastructure Monitor includes two command line utilities for backing up and restoring the contents of your DataStore. These utilities (fulldatabasedump and fulldatabaseimport) extract and compress the data from your DataStore. For information on how to use these utilities, see Exporting and Importing Your DataStore.

Edit the uptime.conf file

To change the default database settings in the uptime.conf file:

  1. Stop the Uptime Infrastructure Monitor services.
  2. Open the uptime.conf file in a text editor.
  3. The first block of settings in the file (starting with dbDriver=com.mysql.jdbc.Driver) contain the MySQL parameters. Either delete this block or comment it out using the hash symbol (#).
  4. If you are using SQL Server as your new DataStore, remove the hash signs (#) from the entry that begins with dbDriver=net.sourceforge.jtds.jdbc.Driver and edit the following settings:
    • dbHostname=

      The name or IP address of the computer on which the database is running (default is localhost).

    • dbPort=

      The number of the port on which the database is listening (default is 1433).

    • dbName=

      The name of the Uptime Infrastructure Monitor database (default is uptime).

    • dbUsername=

      The name of the default database user (default is uptime).

    • dbPassword

      The password for the default database user (default is uptime).

  5. If you are using Oracle as your DataStore, remove the hash signs (#) from the entry that begins with dbDriver=oracle.jdbc.OracleDriver and edit the following settings:
    • dbHostname=

      The name or IP address of the computer on which the database is running (default is oraserv).

    • dbPort=

      The number of the port on which the database is listening (default is 1521).

    • dbName=

      The name of the Uptime Infrastructure Monitor database (default is uptime).

    • dbUsername=

      The name of the default database user.

    • dbPassword

      The password for the default database user.

  6. Save the file.
  7. Restart the Uptime Infrastructure Monitor services.