How to Backup and Restore the Spectrum Reporting Manager (SRM) reporting and archive databases.
Release: Any
Component: SPCRPT
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