Niblett, David A wrote: > Just a curious question for other out there. How are you > all handling backup's (I assume a standard DB dump and > store it somewhere)? > > The next obvious item is restoring one users mailbox for > some reason or another. Anyone have a slick way of doing > this rather than restore the entire DB, pick out who you > want and copy it back? > > I'm getting to the point that a 25+G DB is kinda a PITA to > restore if I need to get one users email back. > > Any ideas?
You can use dbmail-export to dump whole mailboxes. Very crude and basic, and easily extendable: currently: dbmail-export -u username -m mailboxname -o username/mailboxname.mbox consider: dbmail-export -u username -m 'clients/*' dbmail-export -u username -m '*' dbmail-export ... -d since 'start date' dbmail-export ... -d before 'end date' that would allow for useable and effective recovery policies, for example: 1 or more long term storage dumps per user, updated every month 1 short short term snapshot per user, per day for each day since the last long term dump -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
