Database error assistance requested

[ddougan]

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 :: 13.2.13.3 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.

Many thanks,

Des