BackupPC-users

Re: [BackupPC-users] MySQL dump backup example scripts request

2009-07-06 22:47:25
Subject: Re: [BackupPC-users] MySQL dump backup example scripts request
From: Adam Goryachev <mailinglists AT websitemanagers.com DOT au>
To: philip AT naoj DOT org, "General list for user discussion, questions and support" <backuppc-users AT lists.sourceforge DOT net>
Date: Tue, 07 Jul 2009 11:43:32 +1000
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Philip Tait wrote:
> I have done some searching, and have not been able to find a
> complete working example for properly backing up a MySQL database
> with BackupPC.
>
> If someone would be willing to share their working DumpPreUserCmd
> and DumpPostUserCmd setup for creating MySQL database dumps for
> backup, thus saving me some debug cycles, I'll add this to the Wiki
> page, since this question comes up periodically.
>
I use http://sourceforge.net/projects/automysqlbackup/ as a cronjob
wwhich builds it's own little archive of backups on disk, then
backuppc backs up those files. I don't worry too much about the
accumulating number of backups since backuppc will only store one copy
in the pool. Though every 6 months or so I manually remove some and
keep eventually they will expire from backuppc (12 months later)

Regards,
Adam
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkpSqEQACgkQGyoxogrTyiUibgCgo2U93y6c1nshAX2PYthg3Cmu
h+4AoM/oAkPSQ9IT7+8hVHIy/RTBJr5X
=ZsUA
-----END PGP SIGNATURE-----


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time, 
vendors submitting new applications to BlackBerry App World(TM) will have 
the opportunity to enter the BlackBerry Developer Challenge. See full prize 
details at: http://p.sf.net/sfu/blackberry
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/