Results 1 to 2 of 2

Thread: rebuilding mysql data

  1. #1
    cangeceiro is offline Intermediate Member
    Join Date
    Aug 2006
    Posts
    20
    Rep Power
    8

    Default rebuilding mysql data

    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?

  2. #2
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default zmlmtpinject

    Quote Originally Posted by cangeceiro View Post
    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.
    Bugzilla - Wiki - Downloads - Before posting... Search!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mysql data store rebuild
    By ashelley in forum Administrators
    Replies: 3
    Last Post: 03-23-2010, 03:39 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. Zimbra wont start, only LDAP...
    By redbaron in forum Installation
    Replies: 14
    Last Post: 08-10-2007, 11:17 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •