Problem:
Fails to initialize the DDMdb database because the event table is corrupted and it cannot be repaired either.
Resolution:
1. Stop the MySQL Server
To stop MySQL database server, run the following $SPECROOT/bin/cmdC command on bash shell:
./cmdC <hostname> 2 MYSQL
2. Remove event.MYI and event.MYD files and replace them with 0 size files. Be sure to use exactly the same filenames.
3. Start MySQL database server:
To start MySQL database server, run the $SPECROOT/bin/launchinstdbapp command on bash shell.
./launchinstdbapp <hostname> MYSQL y MYSQL.OUT
4. Log in to MySQL and repair the event table:
cd $SPECROOT/mysql/bin
./mysql -uroot -proot ddmdb (Windows)
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb (Linux/UNIX)
On mysql prompt, run the following:
repair table event USE_FRM;
5. Initialize the DDMdb
Navite to $SPECROOT/SS/DDM directory and run the following command:
./ddm_load -i <LANDSCAPE_HANDLE>