Total crash & data loss of zimbra (human factor)
I have lost all data from db/ databases. I lost ibdata file from mysql, and cause of that, can't read any database in db/data directory. I can't do file undelete, any more. It was too late for that, when I find out what happened.
I have some old beckap, and I can recover almost complet 'zimbra' database, but I am still losing all mails (cause their infos are in mailbox databases) and about 100 mailboxes.
Is there any way I can manualy recover them? (it's not a problem for me to write some scripts to automate process)
;( ;( ;( ;(
You *can* recover the mail...
If the /opt/store directories are still there, you can get the mailbox id for each user using LDAP and the ZIMBRA.MAILBOX table. Then, for each user,
- Find their store directory (should be /opt/zimbra/store/0/<mbox id>/msg)
- Use zmlmtpinject to add all messages in subfolders beneath that directory to the correct user's mailbox
You'll lose contacts (etc.) and the messages will be dated as received today, but it'll work.
If you have further script-fu, before calling zmlmtpinject you can edit all the messages to have an X-Zimbra-Received header identical to the message's Date header, and the messages will be added as if they were received on the sent date rather than today.