How to initialize the DDMdb when the event table is corrupted

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

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>