The final quick-and-dirty way to get something functional again. I'd still prefer something to be able to rebuild the entries from the messages themselves, but this allows quick access.
Nuke the trash and create table structure:
Quote:
sudo su - zimbra
drop database mailbox3;
create database mailbox3;
create table mailbox3.mail_item like mailbox2.mail_item;
create table mailbox3.appointment like mailbox2.appointment;
create table mailbox3.tombstone like mailbox2.tombstone;
create table mailbox3.open_conversation like mailbox2.open_conversation;
insert into mailbox3.mail_item select * from mailbox2.mail_item where id <= 11;
|
Ok, copy out your old messages (just looking at 0 for now), nuke the store and then re-insert via zmlmtpinject (glad I read the migration thread). This will basicly re-deliver the messages, so timestamps will be off.
Quote:
cd /opt/zimbra/store/0/3/msg/
rsync -av 0 /var/tmp
cd 0
rm -f *
cd /var/tmp/0
zmlmtpinject -r user -s root -D yourdomain.com *
|
This is not a substitute for a proper backup/restore. This is a "Huh? The analyst took the backups home and they were *stolen*?" last ditch to get the service back. Better methods welcomed.
Off to read the backup threads..