1. Log into the system as the user that owns the Spectrum installation
2. If on Windows, start a bash shell by running "bash -login"
3. Stop the MySQL Server:
a. cd to the $SPECROOT/bin directory
b. Enter the following command where <HOSTNAME> is the hostname of the SpectroSERVER system:
./cmdC <HOSTNAME> 2 MYSQL
4. cd to the $SPECROOT/mysql/data/ddmdb directory and remove the event.MYI and event.MYD files and replace them with 0 size files. Be sure to use exactly the same filenames.
5. Start MySQL database server:
a. cd to the $SPECROOT/bin directory
b. Enter the following command where <HOSTNAME> is the hostname of the SpectroSERVER system:
./launchinstdbapp <HOSTNAME> MYSQL y MYSQL.OUT
6. Repair the talbe
a. cd to the $SPECROOT/mysql/bin directory
b. Enter the following command to log into mysql:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb
c. Enter the following command at the mysql prompt:
repair table event USE_FRM;
d. Enter "exit" at the mysql prompt to exist mysql
7. Reinitialize the DDM database:
a. cd to the $SPECROOT/SS/DDM directory
b. Enter the following command where <LH> is the landscape handle of the SpectroSERVER database:
./ddm_load -i <LH>
8. Start the Archive Manager