Can I Automate OneClick SRM Reporting Database Backups?

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Can I Automate OneClick SRM Reporting Database Backups?

Environment

Release : 10.3

Component : Spectrum Core / SpectroSERVER

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 -proot 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"