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