restoring single user from backup

[cangeceiro]

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?

[glitch23]

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

[cangeceiro]

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

[glitch23]

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.

[cangeceiro]

does this method retain folder structure and timestamps?

[glitch23]

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'

[SOLVED] zmlmptinject challange

[cangeceiro]

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.