dparrish.com

Inspired by Alex King’s recent post on backups, I hacked together this short Perl script that will backup MySQL databases to Amazon’s excellent S3 storage system.

You can download it here. You will need to edit a few configuration items at the top of the script, to include your Amazon Web Services IDs and MySQL details. You will also need the Amazon::S3 and DBI perl modules. You can get them from CPAN.

$ wget -Omysql_s3.pl http://dparrish.com/files/mysql_s3.pl
$ vi mysql_s3.pl (enter your details)
$ chmod 755 mysql_s3.pl
$ ./mysql_s3.pl

It’s probably best to add it to cron so it will run daily. Something like this works nicely:

0 3 * * * perl /home/dparrish/mysql_s3.pl

I’d also suggest using S3 Firefox Organizer to manage your S3 account. It’s a Firefox plugin.

I’ve decided that after 8 months of using Rollout on a daily basis, I should publish a “stable” 1.0 release.

You can get the 1.0 stable release at http://dparrish.com/files/rollout-1.0.tar.gz.

Although this is stable and shouldn’t destroy any of your systems, it does still (and will always) require configuration before it will work for you.

As always, the latest version is available by git:

git clone http://git.dparrish.com/rollout

Comments / bug reports / flames are more than welcome.

Tags: rollout