[SOLVED] Database errors - table didn't close properly

[snake_eyes]

Hello,

Finally I installed zimbra, I check my email today, I noticed the following error message:

Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password={password]
zimbra.jiveID
warning : 1 client is using or hasn't closed the table properly

What does mean it? is there any thing I supposed to do it?

Cheers,

[uxbod]

You can just run a repair table on it and that should resolve the problem.

[snake_eyes]

Is there any command to do it? how do I repair it?

Thank you

[uxbod]

su - zimbra
mysql
use zimbra
repair table jiveID

I have also removed your MySQL password from the previous post

[snake_eyes]

Originally Posted by uxbod

su - zimbra
mysql
use zimbra
repair table jiveID

I have also removed your MySQL password from the previous post

Thank you my dear for cooperation and taking care of this matter

Cheers,