Migrating Your DataStore To a New Database

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:

• Back up and restore the DataStore
• Edit the uptime.conf file

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.