[Cialug] Backup script, did I miss anything?

[Matthew Nuzum]

The great thing about SQL dumps is that they compressed very well.

Things to consider:
 * How will you know if something went wrong? You can check for a non-zero
exit code and send an e-mail in case of error.

 * The number one issue I've had with backup scripts like this[1] is that
the server runs low on disk space. Checking if disk capacity is 90% full
and sending a notification[2] can save headaches later.

 * Have you done a test restore?

All said, looks good and simple.

[1] mine is not that much different except that it copies to S3 and I
backup a few other folders
[2] I'm migrating away from a local mail server to using Sendgrid (Mandrill
by Mailchimp is similar). It's easy, it's free for up to about 200 messages
per day, is more likely to hit my inbox and not spam folder and it works
even if the server fs is full. So far my progress on this migration is
proof of concept and mentally working out the details. I haven't actually
made the jump yet.

On Wed, Dec 24, 2014 at 6:20 PM, David Champion <dchamp1337 at gmail.com>
wrote:

> As Scott pointed out, you're not compressing your mysqldump, if you're
> concerned about space at all just add:
>
> gzip $DESDIR/$MYSQLDBNAME-$TIME.sql 2>&1 >> $LOG
>
> I've started messing with Crashplan, not sure I really love it, but
> features like de-dupe are nice.
>
> -dc
>
> On Wed, Dec 24, 2014 at 5:50 PM, Rob Cook <rdjcook at gmail.com> wrote:
>
> > Yes it is, but I've used it in the past and while rsnapshot worked it
> also
> > failed on me so I'm a bit soured to it. Secondly, this script works and
> is
> > done, I'd be reinventing the wheel again so to speak. I'm just wanting to
> > have a once over by another set of eyes to make sure I didn't miss
> > anything. Also it's good to think and learn, writing this did both for
> me.
> >
> > On Wed, Dec 24, 2014 at 4:08 PM, L. V. Lammert <lvl at omnitec.net> wrote:
> >
> > > On Wed, 24 Dec 2014, Rob Cook wrote:
> > >
> > > Why not KISS? rsnapshot is your friend, ..
> > >
> > >         Lee
> > > _______________________________________________
> > > Cialug mailing list
> > > Cialug at cialug.org
> > > http://cialug.org/mailman/listinfo/cialug
> > >
> > _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > http://cialug.org/mailman/listinfo/cialug
> >
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>



-- 
Matthew Nuzum
newz2000 on freenode, skype, linkedin and twitter

♫ You're never fully dressed without a smile! ♫