rebuilding mysql data

[cangeceiro]

we had a bit of a snaffu with our zimbra server. now all of the mysql mailbox information is gone. but everything in the "store" directory still exists. is there a way to rebuild the mysql databases so we dont loose any messages?

[dkarp]

Originally Posted by cangeceiro

we had a bit of a snaffu with our zimbra server. now all of the mysql mailbox information is gone. but everything in the "store" directory still exists. is there a way to rebuild the mysql databases so we dont loose any messages?

Do you have backups? Restoring from backups would solve your problems.

If no backups, you can still add those messages to the mailstore using zmlmtpinject. Each subdirectory of /opt/zimbra/store/0 is a single user's mailbox. Determine which user owns each such subdirectory, then use zmlmtpinject to inject every message under /opt/zimbra/store/0/<id>/msg.

Note that you'll lose all your folders, tags, contacts, appointments, etc, but something's better than nothing.