Skip to content

Instantly share code, notes, and snippets.

@beatep
beatep / db.rake
Created June 1, 2012 11:01 — forked from edjames/db.rake
Rake task for MySQL data import
namespace :db do
namespace :data do
desc "Load data from sql script file (FILENAME=[data file]) into offices table"
task :load_mysql_dump => 'environment' do
environment = (ENV.include?("RAILS_ENV")) ? (ENV["RAILS_ENV"]) : 'development'
ENV["RAILS_ENV"] = RAILS_ENV = environment
database = Rails.configuration.database_configuration[Rails.env]["database"]
user = Rails.configuration.database_configuration[Rails.env]["username"]
password = Rails.configuration.database_configuration[Rails.env]["password"]