An update of myself, more for the curious (since most people would simply tell 'em "Nope, it's all gone" and recreate the user) and perhaps Google.
/opt/zimbra/db/create_database.sql has a few useful comments for the curious. You can use that as a reference for creating a new replacement database.
Comparing some other databases, I see that the first 11 rows for mail_item are the same, as the define the basic folders. The only changes are to the timestamp, which I'm not that worried about. Inserting these rows into the new mail_item (insert row 11 first and then rows 1-10 to avoid key constraint issues), make sure postfix is running correctly (lmtp tends to die when it can't query the mailbox db) and flush the queue.
Hey, queue empties and mail flows. Next is to "recover" the old mail. The messages are still in the message store, but the mailbox db knows nothing about them.
Zimbra-peeps: I hope I'm not revealing any secret-sauce from the Network Edition by accident. |