Page History

...

In addition to backing up the Uptime DataStore, it is also important to back up the Uptime configuration files and any customized files. Be sure to follow the recommendations in the Other Files and Directories to Back up section at the bottom of this article.

Option 1: Creating a tar or zip archive

One backup option is to regularly create tar or zip archives of your /datastore directory. This is the most straightforward method but requires Uptime Infrastructure Monitor to be stopped during the backup period.

To use this method, simply include the /datastore directory in the tar/zip archive. If you need to recover your DataStore from a tar/zip archive, ensure that all Uptime Infrastructure Monitor services are stopped and that you delete the existing /datastore files before extracting your archive.

1. Stop the Uptime Infrastructure Monitor services.
2. Archive the datastore directory.
   • On a Windows system:
     1. Locate the Uptime Infrastructure Monitor install directory (default C:\Program Files\uptime software\uptime).
     2. Archive the \datastore directory (using an archiving tool such as Winzip).
     3. Move the zip archive to another system or drive.
   • On a Unix system, enter the following commands:
     

     Code Block
     language sql
     # cd /usr/local/uptime OR cd /opt/uptime (depending on the OS) # tar -cvf uptime_backup.tar datastore # gzip uptime_backup.tar

     
     
     
3. Start the Uptime Infrastructure Monitor services. -Review Starting (or restarting) and stopping UIM

Option 2: Using the mysqldump tool

mysqldump is a free utility included with the standard UIM MySQL database. This tool exports DataStore contents into a human readable .sql file that you can use to recreate your DataStore. The commands below detail how to export both configuration and performance data using mysqldump.

...

By adding > mybackup.sql to the commands below, all mysqldump data is directed to the mybackup.sql file. Change the mybackup.sql file name to a date-stamped file name for easy reference.

Exporting your entire datastore

mysql/bin/mysqldump --single-transaction -uuptime -puptime -P3308 --protocol=tcp uptime > mybackup.sql

Exporting only your configuration information

In Uptime Infrastructure Monitor 7.2 or later there is the feature to generate a problem report with configuration via the command line. You can schedule the execution of the command line problem report with a cron job or scheduled task.

...

mysql/bin/mysqldump -uuptime -puptime -P3308 --protocol=tcp
--ignore-table=uptime.erdc_decimal_data
--ignore-table=uptime.erdc_int_data
--ignore-table=uptime.erdc_string_data
--ignore-table=uptime.ranged_object_value
--ignore-table=uptime.performance_aggregate
--ignore-table=uptime.performance_cpu
--ignore-table=uptime.performance_disk
--ignore-table=uptime.performance_esx3_workload
--ignore-table=uptime.performance_fscap
--ignore-table=uptime.performance_lpar_workload
--ignore-table=uptime.performance_network
--ignore-table=uptime.performance_nrm
--ignore-table=uptime.performance_psinfo
--ignore-table=uptime.performance_sample
--ignore-table=uptime.performance_vxvol
--ignore-table=uptime.performance_who
--ignore-table=uptime.archive_delenda 
uptime > mybackup.sql

Exporting only your historical performance data

mysql/bin/mysqldump -uuptime -puptime -P3308 --protocol=tcp uptime 
performance_aggregate
performance_cpu 
performance_disk 
performance_esx3_workload 
performance_fscap 
performance_lpar_workload 
performance_network 
performance_nrm 
performance_psinfo 
performance_sample 
performance_vxvol 
performance_who 
erdc_decimal_data 
erdc_int_data
erdc_string_data > mybackup.sql

Importing your backup data

...

resetdb really --nodata

Option 3: MySQL replication

MySQL replication is the most complex backup method but is the most powerful for quick recovery. MySQL's built-in replication feature will maintain a completely up-to-date copy of your DataStore on another database instance (on the local system or a secondary server). This copy can be quickly set up to act as the primary DataStore in the event of a failure, or can be easily copied from the replication server to the primary server in the event of an outage.

...

• MySQL Online Documentation: How to set up replication.
• Uptime Infrastructure Monitor KB article: Setting up a reporting instance.

Option 4: Oracle data pump

If your DataStore is running on Oracle, you can use the Data Pump utility to export data from an Oracle database. Refer to the Oracle database utilities page for more information: 

• Oracle Database Utilities

Option 5: SQL Server backup

If your DataStore is running on Microsoft SQL Server, you can use the SQL Backup tool to export data. Refer to the Microsoft Developer Network for more information:

• SQL Server Backup

Other files and directories to back up

The following files and directories listed in this section are not part of the DataStore but should also be backed up on a regular basis as well.

...