How to Backup and Restore CA Spectrum Reporting Manager Database .

book

Article ID: 40262

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

How to Backup and Restore the Spectrum Reporting Manager (SRM) reporting and archive databases.



Environment

Release:
Component: SPCRPT

Resolution

Back Up CA Spectrum Reporting and Archive Data:

1. Log into the SRM system as the user that owns the Spectrum installation

2. Shutdown tomcat

3. If Windows, start a bash shell by running "bash -login"

4. cd to the $SPECROOT/mysql/bin directory
    a. Enter the following command to backup the reporting database replacing {backup filename} with a name for the backup file:

./mysqldump --defaults-file=../my-spectrum.cnf --routines --databases -uroot -proot reporting > {backup filename}.sql

    b. Enter the following command to backup the archive database replacing {backup filename} with a name for the backup file:

./mysqldump --defaults-file=../my-spectrum.cnf --routines --databases -uroot -proot archive > {backup filename}.sql

5. Start tomcat




Restore CA Spectrum Reporting and Archive Data

1. Log into the SRM system as the user that owns the Spectrum installation

2. Shutdown tomcat

3. If Windows, start a bash shell by running "bash -login"

4. cd to the $SPECROOT/mysql/bin directory
    a. Enter the following command to restore the reporting database replacing {backup filename} with a name for the reporting backup file:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting < {backup filename}.sql


b. Enter the following command to restore the archive database replacing {backup filename} with a name for the archive backup file:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot archive < {backup filename}.sql

5. Start tomcat


 

Additional Information

Please reference the "Back Up CA Spectrum Reporting and Archive Data" section of the documentation for more information.