Running Zimbra OSE 5.11 on RedHat EL 5.3
The system is sending and receiving mail fine, however changes to preferences etc do not persist after nightly shutdown for backup.
Need some advice on the best way of repairing some mysql tables. After a hard server crash some odd behavior I checked for corrupted disk and a few other things. Ran a check on the database after receiving an error during an attempt to upgrade to 6.x. Restored from backup and ran the following:
Code:
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password --all-databases --auto-repair
which output the following:
Code:
mboxgroup25.appointment
Error : Table 'mboxgroup25.appointment' doesn't exist
error : Corrupt
mboxgroup25.data_source_item
Error : Table 'mboxgroup25.data_source_item' doesn't exist
error : Corrupt
mboxgroup25.imap_folder
Error : Table 'mboxgroup25.imap_folder' doesn't exist
error : Corrupt
mboxgroup25.imap_message
Error : Table 'mboxgroup25.imap_message' doesn't exist
error : Corrupt
mboxgroup25.mail_item
Error : Table 'mboxgroup25.mail_item' doesn't exist
error : Corrupt
mboxgroup25.open_conversation
Error : Table 'mboxgroup25.open_conversation' doesn't exist
error : Corrupt
mboxgroup25.pop3_message
Error : Table 'mboxgroup25.pop3_message' doesn't exist
error : Corrupt
mboxgroup25.revision
Error : Table 'mboxgroup25.revision' doesn't exist
error : Corrupt
mboxgroup25.tombstone
Error : Table 'mboxgroup25.tombstone' doesn't exist
error : Corrupt
zimbra.mobile_devices
Error : Table 'zimbra.mobile_devices' doesn't exist
error : Corrupt
mboxgroup25.appointment
Error : Table 'mboxgroup25.appointment' doesn't exist
error : Corrupt
mboxgroup25.data_source_item
Error : Table 'mboxgroup25.data_source_item' doesn't exist
error : Corrupt
mboxgroup25.imap_folder
Error : Table 'mboxgroup25.imap_folder' doesn't exist
error : Corrupt
mboxgroup25.imap_message
Error : Table 'mboxgroup25.imap_message' doesn't exist
error : Corrupt
mboxgroup25.mail_item
Error : Table 'mboxgroup25.mail_item' doesn't exist
error : Corrupt
mboxgroup25.open_conversation
Error : Table 'mboxgroup25.open_conversation' doesn't exist
error : Corrupt
mboxgroup25.pop3_message
Error : Table 'mboxgroup25.pop3_message' doesn't exist
error : Corrupt
mboxgroup25.revision
Error : Table 'mboxgroup25.revision' doesn't exist
error : Corrupt
mboxgroup25.tombstone
Error : Table 'mboxgroup25.tombstone' doesn't exist
error : Corrupt
zimbra.mobile_devices
Error : Table 'zimbra.mobile_devices' doesn't exist
error : Corrupt
What's the best method of fixing this?
Thanks!
jimbo