How to Backup and Restore CA Spectrum Reporting Manager Database .

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.