Backups

Hi all.

I've been using mysqldump ( and the binary logs ) to backup
our
databases, including dbmail.

This works, but restores are *incredibly* slow. We've got
almost 20GB of
email. Whenever we restore, we only want to restore 1
account, and not
everything at once. So I looked at dbmail-export, which
dumps to the
mbox format, but this doesn't work for us, as our folder
structure
doesn't seem compatible with mbox. Anyway, dbmail-export
only dumps a
small percentage of stuff, and we don't get any of the
folder structure.

Are there any alternatives that will allow us to backup
individual
accounts?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasaknusconsulting.com.au
website: http://www.nusconsult
ing.com.au

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

What problem are you having with mailbox structure and
dbmail-export? If
you have mailboxes that contain subfolders and email, we
support that by
simply adding a .mbox suffix to the mbox files. So you might
end up
with...

INBOX.mbox
INBOX/Foo.mbox
INBOX/Foo/Bar.mbox

Are you finding messages that dbmail-export does not export?
Could be a
bug - more details, please!

Aaron


On Wed, Jul 25, 2007, Daniel Kasak <dkasaknusconsulting.com.au> said:

> Hi all.
> 
> I've been using mysqldump ( and the binary logs ) to
backup our
> databases, including dbmail.
> 
> This works, but restores are *incredibly* slow. We've
got almost 20GB of
> email. Whenever we restore, we only want to restore 1
account, and not
> everything at once. So I looked at dbmail-export, which
dumps to the
> mbox format, but this doesn't work for us, as our
folder structure
> doesn't seem compatible with mbox. Anyway,
dbmail-export only dumps a
> small percentage of stuff, and we don't get any of the
folder structure.
> 
> Are there any alternatives that will allow us to backup
individual
> accounts?
> 
> --
> Daniel Kasak
> IT Developer
> NUS Consulting Group
> Level 5, 77 Pacific Highway
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: dkasaknusconsulting.com.au
> website: http://www.nusconsult
ing.com.au
> 
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

-- 



_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Daniel Kasak wrote:
> Hi all.
> 
> I've been using mysqldump ( and the binary logs ) to
backup our
> databases, including dbmail.
> 
> This works, but restores are *incredibly* slow. We've
got almost 20GB of
> email.

Have you looked at LVM snapshots? The idea is basically to
have your 
entire Database on a LVM volume (it doesn't have to be a
multidisk 
aggregation, just the LVM layer is what matters). Then you
can use the 
mysql client to issue a flushing lock, create a snapshot
block device, 
and release the lock. After this you have an atomic snapshot
of the 
latest database, which you can simply tar away. Restore from
a backup 
then is as simple as stopping mysql for 5 seconds,
copying(renaming) the 
directory containing your data, tarting mysql.

If you find this promising and can not find enough
information on the 
internet, let me know and I will put together a more
detailed explanation.
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail