Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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

  • Stop the up.time data collector:

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

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

 

  • Dump the database: > / scripts / fulldatabasedump
  • Set up the SQL Server database.
  • Edit the uptime.conf file to point to the new database by commenting our the MySQL lines and uncommenting the SQL Server lines.  Example:

 

           #dbDriver=com.mysql.jdbc.Driver

           #dbType=mysql

           #dbHostname=localhost

           #dbPort=3308

           #dbName=uptime

           #dbUsername=uptime

           #dbPassword=uptime

 

      #example SQL Server configuration

         dbDriver=net.sourceforge.jtds.jdbc.Driver

         dbType=mssql

         dbHostname=localhost

         dbPort=1433

        dbName=uptime

        dbUsername=user

        dbPassword=password

 

  •  Stop the MySQL database:

 

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

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

 

  • Initialize the database: > / resetdb --nodata really
  • Import the database to SQL Server: > / scripts / fulldatabaseimport
  • Start the data collector:

 

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

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

  • No labels