Automatically backup MySQL to Amazon S3 (and a dog)
I’ve been revisiting my backup scripts today and I decided to publish my notes on how to backup your MySQL databases to Amazon S3 - I forgot just how simple it was:
- Install s3cmd
- Write a bash script that…
- lists your databases
- dumps them to a temporary file
- uploads them to s3
- deletes the temporary file
- Run it with cron every night
The full instructions are here:
(and a dog)
I’m gonna meet this pup at the NESSR Easter Event next weekend
