Hi all,

I have several pesky errors in /opt/zimbra/log/mysql.log of;

120912 18:35:23 InnoDB: Error: page 3070 log sequence number 6 3371828114
InnoDB: is in the future! Current system log sequence number 6 3371823370.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: MySQL :: ::
InnoDB: for more information.

I have been good and read many posts regarding this error (phoenix) and have been able to dump my databases, albeit painfully to a file.

Now, I wish to drop the databases from Zimbra and then bring them back in.

However even from within mysql, I cannot seem to drop them. I can see all of them being;

mboxgroup1-100
mysql
test
zimbra

But I cannot drop anything and get the error;

ERROR 2013 (HY000): Lost connection to MySQL server during query

By the way, I am following this how to;

wiki.zimbra.com/wiki/Harley77-Mysqld

I am using the zimbra mysql user and password found by simply typing zmlocalconfig -s | grep mysql.

By the way, I cannot drop it as the root user either.

Thanks in advance,

- aurf

I am trying to upgrade from OSE 5.0.24 to to OSE 7.2.1 on CentOS 5 and then migrate to CentOS 6 so I have a ways to go.

If I can just get past this error, life will be very good again.