1. On the SRM server, browse to $SPECROOT\mysql\my-spectrum.cnf
Replace $specroot with spectrum install path.
2. turn on the forced recovery, by adding the following to the [mysqld] section:
innodb_force_recovery = 1
* see note 1. below
3. run a mysqlcheck on the entire db to see exactly which tables are corrupted.
4. export the corrupted tables.
mysqldump -defaults-file=../my-spectrum.cnf -uroot -proot reporting bucketactivitylog > dump.sql
5. drop the corrupted tables.
6. turn off forced recovery.
7. import the exported tables from the Mysql dump in step 4.
mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting < dump.sql
* note 1.
innodb_force_recovery is 0 by default (normal startup without forced recovery). The permissible nonzero values for innodb_force_recovery are 1 to 6. A larger value includes the functionality of lesser values. For example, a value of 3 includes all of the functionality of values 1 and 2.
If you are able to dump your tables with an innodb_force_recovery value of 3 or less, then you are relatively safe that only some data on corrupt individual pages is lost. A value of 4 or greater is considered dangerous because data files can be permanently corrupted. A value of 6 is considered drastic because database pages are left in an obsolete state, which in turn may introduce more corruption into B-trees and other database structures.