How do I initialize the Spectrum DDM database to start from scratch?
Use the following steps to initialize the Spectrum DDM database to start from scratch
1. Log into the SpectroSERVER system as the user that owns the Spectrum install.
2. On Windows, start a bash shell by running “bash –login”
3 cd to the $SPECROOT/SS directory
4. Enter the following command and note the landscape handle
../SS-Tools/lh_set
5. cd to the $SPECROOT/bin directory
6. Enter the following command to shut down the Archive Manager where <HOST> is the hostname of the SpectroSERVER system:
./cmdC <HOST> 2 ARCHMGR
7. Bring up mysql prompt by running:
cd $SPECROOT/MySql/bin
mysql --defaults-file=../my-spectrum.cnf -uroot -proot
8. At the mysql prompt, run commands to DROP and CREATE the ddmdb database:
drop database ddmdb;
create database ddmdb;
exit
9. cd to the $SPECROOT/SS/DDM directory and enter the following command to re-initialize the DDM database where <LH> is the landscape handle noted in step 4 above:
../ddm_load –i <LH>
8. Enter “y” when prompted “Are you sure you want to initialize the DDM Database [y/n]?”
9. cd to the $SPECROOT/bin directory
10. Enter the following command to start the Archive Manager:
./startSS.pl
NOTE: The above “startSS.pl” command will start both the SpectroSERVER and Archive Manager. The script checks to see if either is running. If already running, it will not start another.
Please reference the section of the documentation for more information.