...
Contents
Table of Contents
...
Overview
...
Overview
Performing regular backups of your up.time DataStore is a highly recommended practice. The DataStore is the up.time backbone and holds all configuration information and historical performance data. This article outlines five common methods for backing up your DataStore.
Info | ||
---|---|---|
| ||
These backup methods are intended for a single Monitoring Station. Never attempt to merge two or more Monitoring Station configurations in a single database. |
...
...
Option 1: Creating a tar or zip Archive
...
Exporting Your Entire DataStore
Code Block |
---|
mysql/bin/mysqldump --single-transaction -uuptime -puptime -P3308 --protocol=TCP uptime > mybackup.sql
|
Note | ||
---|---|---|
| ||
The [dbname] variable may be uptime_v4 if your database was created in up.time 4. |
...
Code Block |
---|
prexport [-p] [-cN]
Options:
-p to dump last hour of data
-c dump historical configuration; N is number of months defaults to 3 months
|
Alternatively, here are the configuration tables:
Code Block |
---|
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
...
Note |
---|
Before importing data, you must stop the up.time services (see steps outlined in the Creating a tar or zip Archive section). |
...
To import your backup data, run the following command:
...
Code Block |
---|
resetdb really --nodata |
...
...
Option 3: MySQL Replication
...
- MySQL Online Documentation: How to Set Up Replication.
- up.time KB article: Setting up a Reporting Instance.
...
Option 4: Oracle Data Pump
...