[SOLVED] After a file system failure - EMPTY INBOX

[trapanator]

Hi,

I'm using Zimbra OS 5.0.9.

Yesterday there was a file system (reiserfs) failure, and some files are lost after a reiserfsck.

One of accounts as an inbox of one message, but moving the mouse over the "INBOX" text it tells he has over 2200 messages.

Can I recover them? Rebuilding MYSQL tables?

[phoenix]

Try and re-index the mailbox.

[trapanator]

Try and re-index the mailbox.

how can I do it?

[phoenix]

Go to the Admin UI and in the Account details hit the re-index option.

[trapanator]

it doesn't work. I did a mysqlcheck:

mboxgroup4.appointment
Error    : Table 'mboxgroup4.appointment' doesn't exist
error    : Corrupt
mboxgroup4.imap_folder
Error    : Table 'mboxgroup4.imap_folder' doesn't exist
error    : Corrupt
mboxgroup4.imap_message
Error    : Table 'mboxgroup4.imap_message' doesn't exist
error    : Corrupt
mboxgroup4.mail_item
Error    : Table 'mboxgroup4.mail_item' doesn't exist
error    : Corrupt
mboxgroup4.open_conversation
Error    : Table 'mboxgroup4.open_conversation' doesn't exist
error    : Corrupt
mboxgroup4.pop3_message
Error    : Table 'mboxgroup4.pop3_message' doesn't exist
error    : Corrupt
mboxgroup4.revision
Error    : Table 'mboxgroup4.revision' doesn't exist
error    : Corrupt
mboxgroup4.tombstone
Error    : Table 'mboxgroup4.tombstone' doesn't exist
error    : Corrupt

how can I fix this?

[uxbod]

You could try Mysql Crash Recovery - Zimbra :: Wiki but I would recommend taking a backup of /opt/zimbra first. If it is only MySQL that is broken and the message store is intact then the emails could be recovered by re-injecting them once the database is sorted.

[trapanator]

thank you ! I had to rebuild InnoDB index ... it was too corrupt...