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;
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;
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,
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.