Creates a MySQL dump and backs it up to Rackspace Cloudfiles and maintains 14 days worth of backups

mysql_backup_to_cloudfiles.rb

require 'rubygems'
require 'cloudfiles'
  
cf = CloudFiles::Connection.new(:username => "", :api_key => "")

`mysqldump -u root --password=password --all-databases > /home/deploy/backup.sql`

file = File.new("/home/deploy/backup.sql")

if file
  container = cf.container('backups')
  object = container.create_object "servername_backup_#{file.mtime.strftime("%Y-%m-%d")}.sql", false
  object.write file
end

file.close

backups = container.objects.select{|o| o =~ /servername.+/}

if backups.length > 14
  backups.sort!
  container.delete_object(backups.first)
end