Skip to content

Instantly share code, notes, and snippets.

@oliyoung
Created July 28, 2008 06:02
Show Gist options
  • Save oliyoung/2844 to your computer and use it in GitHub Desktop.
Save oliyoung/2844 to your computer and use it in GitHub Desktop.
backup database and copy it up to a server
#/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment