pauldowman / blog_code_examples

Code examples from my blog

This URL has Read+Write access

raw normal view history
759fe6d4 » pauldowman 2009-02-08 added code for MySQL backup... 1 require "config"
2 require "rubygems"
3 require "aws/s3"
4 require "fileutils"
5
6 def run(command)
7 result = system(command)
8 raise("error, process exited with status #{$?.exitstatus}") unless result
9 end
10
11 def execute_sql(sql)
12 cmd = %{mysql -u#{@mysql_user} -e "#{sql}"}
13 cmd += " -p'#{@mysql_password}' " unless @mysql_password.nil?
14 run cmd
15 end
16
17 AWS::S3::Base.establish_connection!(:access_key_id => @aws_access_key_id, :secret_access_key => @aws_secret_access_key, :use_ssl => true)
18
19 # It doesn't hurt to try to create a bucket that already exists
20 AWS::S3::Bucket.create(@s3_bucket)