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:

...

1. Data Collector:  

   Code Block
   language text
   Unix: #

...

1. /etc/init.d/uptime_core

...

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

...

2. Dump the database:

   Code Block
   language text
   > /scripts/

   fulldatabasedump 

   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 out the MySQL lines and uncommenting the SQL Server lines.
    

   Code Block
   language text
   #dbDriver=com.mysql.jdbc.Driver Driver   #dbType=mysql mysql  #dbHostname=localhost localhost   #dbPort=3308 3308   #dbName=uptime uptime   #dbUsername=uptime uptime   #dbPassword=uptime uptime     #example SQL Server configuration configuration   dbDriver=net.sourceforge.jtds.jdbc.Driver Driver   dbType=mssql mssql  dbHostname=localhost localhost   dbPort=1433 1433   dbName=uptime uptime   dbUsername=user user   dbPassword=password

5. Stop the MySQL database: 

   noformat

   Code Block
   language
   text
   Unix: # /etc/init.d/uptime_datastore stop stop   Windows: > net stop "up.time data store"

6. Initialize the database:

   Code Block
   language text
   > / resetdb --nodata really

7. Import the database to SQL Server:

   Code Block
   language text
   > /scripts/fulldatabaseimport

8. Start the data collector: 

   Code Block

    noformat

   language

   text

   Unix: # /etc/init.d/uptime_core start start   Windows: > net start "up.time data collector"

    

...