My database started to show errors this evening in the ib_logfile1. After researching what was happening (i.e. MySQL failing), I came across this wiki how-to:
Mysql Crash Recovery - Zimbra :: Wiki
I followed it through and was successful in restarting Zimbra; however, when I checked the mysql_error_log, I continued to see the logfile error.
A bit of further searching came up with this article:
Harley77-Mysqld - Zimbra :: Wiki
It's very similar to the first one, except it deletes the ib* files.
I've been trying to get to that point, but I now can't dump the databases - I get errors like this:
mysqldump: Got error: 1146: Table 'zimbra.config' doesn't exist when using LOCK TABLES
In the mysql_error_log, I see the following:
110607 2:04:51110607 2:04:51 [ERROR] MySQL is trying to open a table handle but the .ibd file for
table zimbra/config does not exist.
Have you deleted the .ibd file from the database directory under
the MySQL datadir, or have you used DISCARD TABLESPACE?
See MySQL :: MySQL 5.0 Reference Manual :: 220.127.116.11 InnoDB General Troubleshooting
how you can resolve the problem.
It's now 2.15 a.m. and I'm quite stuck. I would appreciate any assistance in how to get this back up again.