backup database and copy it up to a server

gistfile1.rbx

#/usr/bin/ruby
require 'net/ftp'

@filename    = "date-"+Time.now.strftime("%Y%m%d-%H%M")+".sql"
@db_user     = "db6663"
@db_password = "PASSWORD"
@db_host     = "my.database-server.com"
@database    = "database"
@backupdir   = "/path/to/backup/directory"

puts "/bin/touch #{@backupdir}/#{@filename}"
puts "/usr/bin/mysqldump --user = #{@db_user} --password=#{@db_password} --host=#{@db_host} #{@database} > #{@backupdir}/#{@filename}"
puts "/bin/gzip #{@backupdir}/#{@filename}"

Net::FTP.open('backup.server.com', 'BACKUP', 'PASSWORD') do |ftp|
  files = ftp.list('*')
  ftp.putbinaryfile("#{@backupdir}/#{@filename}")
end