How to Backup and Restore CA Spectrum Reporting Manager Database .

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

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

Environment

Release: Any
Component: SPCRPT

Resolution

NOTE:  In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

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 -p<PASSWD> 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 -p<PASSWD> 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 -p<PASSWD> 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 -p<PASSWD> 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.