Page History

...

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

Backup and Restore the DataStore

...

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 Documenation: Exporting and Importing Your DataStore

Exporting and Importing Your DataStore

...