mysql-restore.rb

#!/usr/bin/env ruby -wKU

# ================================
# = MySQL database backup script =
# ================================
# 
# Restores databases from files named [database_name].sql to a database named [database_name]
# 
# NOTE: will DROP a database before re-creating it. 

DBUSER = ARGV[0]
DBPASSWORD = ARGV[1]

if DBUSER and DBPASSWORD

  Dir["./*.sql"].each do |file|
    filename = File.basename(file, ".sql")
    system("mysql -udbuser -pdbp -e 'drop database #{filename}'")
    system("mysql -udbuser -pdbp -e 'create database #{filename}'")
    system("mysql -udbuser -pdbp  #{filename} < #{file}")  
    puts "Restored #{filename} from #{file}"
  end
else
  puts "Usage: mysql-restore.rb username password"
end