Results 1 to 7 of 7

Thread: restoring single user from backup

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

    Default restoring single user from backup

    Is it possible to restore a single users mailbox from a backup? im backing up nightly by copying the /opt/zimbra directory to a backup folder. I had a user account deleted and i just want to restore that users mailbox to the current running system from these backups. I have found the mailbox in the store directory, but how would i retrieve the necessary mysql information and get it injected into the current system?

  2. #2
    glitch23 is offline Special Member
    Join Date
    Jul 2006
    Location
    New York, NY
    Posts
    122
    Rep Power
    9

    Default

    I can never remember how to do this off the top of my head, but its in the forum somewhere.

    Found it...

    How to restore a single email with the OSS version
    Because we all can't be geniuses, I'll go first.

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

    Default

    this is only for a single email, i need to restore an entire users mailbox

  4. #4
    glitch23 is offline Special Member
    Join Date
    Jul 2006
    Location
    New York, NY
    Posts
    122
    Rep Power
    9

    Default

    The second example in that link will work for all the emails in the backup directory. You can't however restore the Calendar this way, you need the NE addition for that, or the backups you have been doing used a script that also copied the calendar info out of the database.
    Because we all can't be geniuses, I'll go first.

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

    Default

    does this method retain folder structure and timestamps?

  6. #6
    glitch23 is offline Special Member
    Join Date
    Jul 2006
    Location
    New York, NY
    Posts
    122
    Rep Power
    9

    Default

    I don't believe folder structure can be restored with the OSS version, at least not easily or without a script.

    Here's another link for using 'zmmailbox addMessage'

    http://www.zimbra.com/forums/adminis...html#post75524
    Because we all can't be geniuses, I'll go first.

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

    Default

    hmm, Well i think i may have got this with out the need for the command line tools.

    I fired up a spare mysql server with the data, dumped this into a text file via mysql dump. Opened the sql files in a text editor and replaced the mailbox_id with the users new id and removed the CREATE and DROP statements.

    im holding off till the end of the day to try and restore these into the server, but would i be safe to assume that re-inserting this data and copying the file stores into the new user stores will get me going?

    one thing i could not come across any information for though was how zimbra stores folder information. is this in mysql? i couldnt find a table that seemed relevant. I did notice the field "name" in the table "mail_item" that coincided with imap folders for the account.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 21
    Last Post: 02-04-2010, 10:06 AM
  2. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  3. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  4. Services stopped working
    By lilwong in forum Administrators
    Replies: 4
    Last Post: 08-15-2006, 09:19 AM
  5. Fedora Core 3, Clean Install - Not working!
    By pcjackson in forum Installation
    Replies: 17
    Last Post: 03-05-2006, 07:38 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
  •