Can I Automate OneClick SRM Reporting Database Backups?
search cancel

Can I Automate OneClick SRM Reporting Database Backups?

book

Article ID: 188832

calendar_today

Updated On:

Products

CA Spectrum DX NetOps

Issue/Introduction

Can I Automate OneClick SRM Reporting Database Backups?

Environment

Release : Any
Component : Spectrum Report Manager/SRM

Resolution

Spectrum does not currently have an automated process for backing up the SRM 'reporting' MySQL database on the OneClick server. Backups can be executed from the command line and therefore could be scripted and executed either via cron tabs on Linux or Task Scheduler on Windows.


mysqldump
----------------
$SPECROOT/tomcat/bin/stopTomcat.sh
$SPECROOT/mysql/bin/mysqldump --defaults-file=../my-spectrum.cnf --routines --databases -uroot -p<PASSWD> reporting > {backup filename}.sql
$SPECROOT/tomcat/bin/startTomcat.sh



BackupReportingDBLandscape Utility Script (This backs up reporting data for a specific landscape)
-----------------------------------------------------------
$SPECROOT/bin/BackupReportingDBLandscape(.sh|.bat)  <mySQL user>  <MySQL Password>  <LandscapeName> <Description>

example:
$SPECROOT/bin/BackupReportingDBLandscape.sh root root spectrumss25 "MLS SS Report Data Backup"