gistfile1.txt

    #upload the file
    put(File.read("/tmp/#{dbname}-snapshot.sql.bz2"), "/tmp/#{dbname}-snapshot.sql.bz2", :mode => 0666)
    
    #import the database
    run "bzcat /tmp/#{dbname}-snapshot.sql.bz2 | mysql -u #{dbuser} -p #{dbname}" do |ch, stream, out |
      ch.send_data "#{dbpass}\n" if out=~ /Enter password:/
    end