Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Backup and Restore the DataStore

up.time 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.

...

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

  1. Stop the up.time 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 up.time 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 up.time 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 up.time Uptime Infrastructure Monitor services.