config = Rails.application.config database = config.database_configuration[“database”] username = config.database_configuration[“username”] password = config.database_configuration[“password”]

namespace :db do

#rake db:dump
desc "dumps the database to a sql file"
task :dump => :environment do
  puts "Creating #{database}_dump.sql file."
  `mysqldump -u "#{username}" --password="#{password}" "#{database}" > "#{database}"_dump.sql`
end

namespace :dump do
  #rake db:dump:import
  desc "imports the #{database}_dump.sql file to the current db"

  task :import do
    `mysql -u root --password="#{password}" "#{database}" < "#{database}"_dump.sql`
  end
end

end