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

   data collector

   Data Collector:

   
   

     

   Code Block
   language text
   Unix: #

...

1. /etc/init.d/uptime_core stop  Windows: > net stop "up.time data collector"

...

2. Dump the database:

   Code Block
   language text
   > /scripts/fulldatabasedump

3. Set up the SQL Server database.

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

   our

   out the MySQL lines and uncommenting the SQL Server lines. 

    

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

...

1. Driver   #dbType=

...

1. mysql  #dbHostname=

...

1. localhost   #dbPort=

...

1. 3308   #dbName=

...

1. uptime   #dbUsername=

...

1. uptime   #dbPassword=

...

1. uptime

...

1. #example SQL Server

...

1. configuration

...

1. dbDriver=net.sourceforge.jtds.jdbc.

...

1. Driver

...

1. dbType=

...

1. mssql

...

1. dbHostname=

...

1. localhost

...

1. dbPort=

...

1. 1433

...

1. dbName=

...

1. uptime

...

1. dbUsername=

...

1. user

...

1. dbPassword=password

...

1.  Stop

2. Stop the MySQL database:

    

   Code Block
   language text
   Unix: #

    Unix: #

   /etc/init.d/uptime_datastore

   stop Windows: > net stop

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

3. Initialize the database:

   Code Block
   language text
   > / resetdb --nodata really

4. Import the database to SQL Server:

   Code Block
   language text
   > /scripts/fulldatabaseimport

5. Start the data collector: 

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

   start

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