articleMigrating Your DataStore To a New Database

Related Documentation Version of up.time affected Affected Platforms
Exporting and Importing Your DataStore 4.4 or newer All

up.time uses MySQL as its default DataStore although MS SQL Server and Oracle are also supported. Please see Supported Databases in up.time 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

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

Related Articles


Moving or Migrating the up.time Monitoring Station

RatingViews
article

By: uptime Support | Date Created: 10-26-2005 | Last Modified: 6-14-2013 | Index: 022

  9640

Exporting and Importing Your DataStore or Configuration

RatingViews
article

This article explains the DataStore export and import utilities.

By: uptime Support | Date Created: 2-13-2007 | Last Modified: 12-19-2012 | Index: 140

  6100

Shrinking your MySQL DataStore

RatingViews
article

At times it may be necessary to reduce the disk space that your MySQL DataStore consumes on your monitoring station. The process of reducing your DataStore size follows the general steps that are...

By: uptime Support | Date Created: 7-31-2006 | Last Modified: 2-19-2014 | Index: 088

  11553

Default MySQL Database Users and Permissions

RatingViews
article

This article outlines the MySQL database users that are installed with up.time and their permissions

By: uptime Support | Date Created: 7-6-2007 | Last Modified: 6-28-2011 | Index: 211

  3769

Backing up & Recovering up.time

RatingViews
article

This article outlines five ways to back up your up.time DataStore.

By: uptime Support | Date Created: 10-7-2006 | Last Modified: 10-24-2013 | Index: 093

  11771

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement