How to initialize the DDMdb when the event table is corrupted

Document ID : KB000031996
Last Modified Date : 14/02/2018
Show Technical Document Details


Fails to initialize the DDMdb database because the event table is corrupted and it cannot be repaired either.



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>