Saturday, April 26, 2008

Rollout Moved

There’s been enough actual interest in Rollout for me to move it to a community site. I chose Google Code because I work there, and it’s much faster than Sourceforge.

The new URL for Rollout is:

Unfortunately they don’t support git, so I have to deal once again with Subversion.

The new checkout instructions are:
svn checkout rollout

The manual is online there, and an issue tracker, so submit bugs!

Tuesday, February 19, 2008

MySQL Backup to Amazon S3

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
$ vi (enter your details)
$ chmod 755
$ ./

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

0 3 * * * perl /home/dparrish/

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