Date: Fri, 29 Mar 2024 06:49:01 +0000 (UTC) Message-ID: <1876749454.5643.1711694941223@ip-10-0-1-161.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_5642_989598318.1711694941219" ------=_Part_5642_989598318.1711694941219 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
To keep your historical performance data and migrate your Uptime= Infrastructure Monitor datastore from a MySQL database to SQL Server, plea= se 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 d= atabase:
> /= scripts/fulldatabasedump
Edit the <= strong><uptime_dir>\uptime.conf and <uptime_dir&g= t;\controller\resources\uptime_controller.conf file to point to th= e new database by commenting out the MySQL lines and uncommenting the SQL S= erver lines. = span>
#dbDriv= er=3Dcom.mysql.jdbc.Driver #dbType=3Dmysql #dbHostname=3Dlocalhost #dbPort=3D3308 #dbName=3Duptime #dbUsername=3Duptime #dbPassword=3Duptime #example SQL Server configuration dbDriver=3Dnet.sourceforge.jtds.jdbc.Driver dbType=3Dmssql dbHostname=3Dlocalhost dbPort=3D1433 dbName=3Duptime dbUsername=3Duser dbPassword=3Dpassword
Stop the M= ySQL 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:
> /s= cripts/fulldatabaseimport
Start the = data collector:
Unix: #= /etc/init.d/uptime_core start Windows: > net start "up.time data collector"