Skip to content

Instantly share code, notes, and snippets.

@RobinStamer
Created February 3, 2013 17:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RobinStamer/4702786 to your computer and use it in GitHub Desktop.
Save RobinStamer/4702786 to your computer and use it in GitHub Desktop.
<ChIkEn> I'm setting up a script to auto backup the DB
<RobinStamer> Those aren't hard
<ChIkEn> I do not believe I ever said that it would be hard
<RobinStamer> *shrugs*
<RobinStamer> Only major issue I've ever had with one was because certain crond's treat % as a special character and it was chocking errorlessly on my date-naming command :/
<ChIkEn> The database compresses really well
<ChIkEn> 77
<ChIkEn> 77% deflated
<ChIkEn> takes roughly 1 minute to dump, zip, and copy it off site
<RobinStamer> Hopefully you have steps to actually test the backups
<ChIkEn> Not really neccessary
<RobinStamer> Actually, yes it is
<RobinStamer> A bad backup is worse than no backup
<ChIkEn> No, it really isn't
<ChIkEn> None of the tools I am using are unstable
<ChIkEn> The only time it would ever have an issue would be because of MySQL corruption
<ChIkEn> Which we would notice beforehand
<ChIkEn> and guess what
<ChIkEn> We'd have backups to fix that
<ChIkEn> :)
<RobinStamer> BZZT
<ChIkEn> ls
<ChIkEn> derp
<RobinStamer> Backups can fail for other reasons
<ChIkEn> No really, it's fine
<ChIkEn> I get it
<ChIkEn> you like to act like some elite c0d3r
<ChIkEn> I really don't care
<RobinStamer> Eg: the media they write to fails, one of the tools fails silently, etc...
<ChIkEn> It'll be fine
<RobinStamer> Your loss
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment