On 06/10/05, Odhiambo Washington (wash@wananchi.com) wrote:
- On 06/10/05 21:20 +0100, Rory Campbell-Lange wrote:
On 06/10/05, Odhiambo Washington (wash@wananchi.com) wrote:
- On 06/10/05 16:06 +0100, Gabe Granger wrote:
I'm currently doing nightly full backups of /home. I'm not sure if a
full back up is the best way to do backups. .... Not very good for restoring mailboxes/maildirs though. Sorry for the digression!So, what happens if the client was to ask you for a backup of mail that he received last June? ;)
SELECT
*
FROM
mail
WHERE
user = client
and
dateinserted >= '2004-06-01'
and
dateinserted < '2004-07-01'We can send the client the list of headers from the sql query and they can pick the messages they need, then we pull that back from tape. We back a month's pool of messages to tape over smb every week.
Obviously, this backup system has more to do with proving that the office in question got/sent an email than pulling back a whole Maildir/Mailbox.
Rory
--
Rory Campbell-Lange
rory@campbell-lange.net