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:

...

1.   

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

...

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

...

2. Dump the database: > / scripts / fulldatabasedump 
3. Set up the SQL Server database.

4. Edit the uptime.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  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  Windows: > net start "up.time data collector"