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