This article is for all versions of Amanda Enterprise (AE)
In /opt/zmanda/amanda/logs/zmc_gui_errors.log you may see the following error:
MySQL error #145: Table './zmc/events' is marked as crashed and should be repaired
Or during ZMC startup you see the following:
/opt/zmanda/amanda/mysql//bin/mysqladmin.bin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/opt/zmanda/amanda/mysql/tmp/mysql.sock' (111)' and when you check /opt/zmanda/amanda/mysql/data/mysqld.log, you find indications of crashed tables.
To repair the ZMC database, use the following procedure. Please note:
Run the following command as the root user:
# /opt/zmanda/amanda/bin/zmc-db-repair.sh
Check the command logs for errors. If there are errors, please contact Zmanda Support team.