MySQL DB corrupt
my DB got corrupted after a system crash. I tried several DB checks but nothing worked till now and if I try to upgrade from 5.0.8_GA to 5.0.10_GA I am getting the following error:
Do you want to verify message store database integrity? [Y]
Verifying integrity of message store databases. This may take a while.
mysqld is alive
/opt/zimbra/mysql/bin/mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... CHANGED'
Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=Xg8RyCgUi2TE2ilc1bCmK1s8UAt7e --auto-repair
error : Corrupt
thanks uxbod for your replay.
I read trou the thread, but it's to confusing to me.
If I check the Status everything sems OK but still it does not work and the only errors I can see is the above mentoned errors
zimbra@zimbra2:~$ zmcontrol status
is there a way I can repair the MySQL DB?
It would appear you need to follow this Wiki :- Mysql Crash Recovery - Zimbra :: Wiki. Though make sure you backup your system first !!! ;)