Page History

To keep your historical performance data and migrate your MySQL database to SQL Server, please complete the following steps:

1. Stop the up.time data collector:

 

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

...

1. Dump the database: > / scripts / fulldatabasedumpfulldatabasedump 
2. Set up the SQL Server database.

3. Edit the uptime.conf file to point to the new database by commenting

   our

   out the MySQL lines and uncommenting the SQL Server lines.

    

   
    

   Code Block

...

1. #dbDriver=com.mysql.jdbc.

...

1. Driver  #dbType=mysql

...

1. #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=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:

   No Format

    Unix

   Unix: # /etc/init.d/uptime_datastore

   stop Windows: > net stop

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

   
   

3. Initialize the database: > / resetdb --nodata really
4. Import the database to SQL Server: > / scripts / fulldatabaseimport

5. Start the data collector:
    

   No Format
   Unix: # /etc/init.d/uptime_core

   start

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