bit of my astrails-safe file, showing mysql command line batch execution

backup.rb

  mysqldump do
    options "-ceKq --single-transaction --create-options"

    username = "some"
    pass = "thing"

    user username
    password pass
    socket "/var/run/mysqld/mysqld.sock"

    dbs = IO.popen("/usr/bin/mysql -u #{username} -p#{pass} -e 'show databases' --batch --skip-column-names")
    databases = dbs.readlines
    dbs.close
    databases.each do |db|
      database db.chomp.to_sym
    end
  end