Page History

To keep your historical performance data and migrate your Uptime Infrastructure Monitor datastore from a MySQL database to SQL Server, please complete the following steps:

1. Stop the up.time

...

1. Data Collector:

...

...

1. Code Block
   language text
   Unix: #/etc/init.d/uptime_core

...

1. stop  Windows: > net stop "up.time data collector"

1. Dump the database:

   Code Block
   language text
   > /scripts/fulldatabasedump

2. Set up the SQL Server database.

3. Edit the <uptime_dir>\uptime.conf and <uptime_dir>\controller\resources\uptime_controller.conf file to point to the new database by commenting

...

1. out the MySQL lines and uncommenting the SQL Server lines. 

...

...

1. Code Block
   language text
   #dbDriver=com.mysql.jdbc.

...

           #dbType=mysql

           #dbHostname=localhost

           #dbPort=3308

           #dbName=uptime

           #dbUsername=uptime

           #dbPassword=uptime

      #example SQL Server configuration

...

1. Driver   #dbType=mysql  #dbHostname=localhost   #dbPort=3308   #dbName=uptime   #dbUsername=uptime   #dbPassword=uptime     #example SQL Server configuration   dbDriver=net.sourceforge.jtds.jdbc.

...

1. Driver   dbType=

...

1. mssql  dbHostname=

...

1. localhost   dbPort=

...

1. 1433   dbName=

...

1. uptime   dbUsername=

...

1. user   dbPassword=password

...

1. Stop the MySQL database: 

   Code Block
   language

...

1. text

...

1. Unix: # /etc/init.d/uptime_datastore

...

1. stop   Windows: > net stop "up.time data store"

...

2. Initialize the database:

   Code Block
   language text
   > / resetdb --nodata really

3. Import the database to SQL Server:

   Code Block
   language text
   > /scripts/fulldatabaseimport

4. Start the data collector: 

   Code Block
   language

...

1. text

...

1. Unix: # /etc/init.d/uptime_core

...

1. start   Windows: > net start "up.time data collector"