MySQL recovery

[hodd]

So I upgraded one of my MTA's this morning to 6.0.9, and for some reason the upgrade was getting stuck on Starting Mysql. Everything I've read points to a corrupt database.

Everything I found points to the Mysql Crash Recovery

When I get to this step:
mysql --batch --skip-column-names -e "show databases" | grep -e mbox -e zimbra > /tmp/mysql.db.list

I get the error below:
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist


I've got a call into support with a server down, but just wanted to reachout to the forums to see if anyone can help as well...

[phoenix]

It really depends on what your exact problem is, there's a couple of threads marked as 'Solved' here: site:zimbra.com +"Fatal error: Can't open and lock privilege tables: Table 'mysql.host'" - Yahoo! Search Results

[FritzBrause]

If your MySQL Server is not starting you may try to repair the table by

/opt/zimbra/mysql/bin/myisamchk -r /opt/zimbra/db/data/mysql/*.MYI

This can fix almost anything on an MyISAM table.

[hodd]

So it turned out that I accidently rm -rf'd the SQL logs...it's was all bad. Even though I ctrl+c'd very quickly when I saw what I had typed, I had to work with support on rebuilding the mysql tables.