...
If you plan to change your DataStore to another supported database, you will need to:
Table of Contents | ||
---|---|---|
|
Backup and Restore the DataStore
...
- Stop the up.time services.
- Open the uptime.conf file in a text editor.
- 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 (#).
- 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).
- dbHostname=
- 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.
- dbHostname=
- Save the file.
- Restart the up.time services.
Related Documenation: Exporting and Importing Your DataStore
Exporting and Importing Your DataStore
...