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:
...
| Code Block | ||
|---|---|---|
| ||
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.
...
| Code Block | ||
|---|---|---|
|
...
#dbDriver=com.mysql.jdbc.Driver |
...
#dbType=mysql |
...
#dbHostname=localhost |
...
#dbPort=3308 |
...
#dbName=uptime |
...
#dbUsername=uptime |
...
#dbPassword=uptime |
...
#example SQL Server configuration
...
#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"