Contents

if File.exist? Rails.root.join('config/database.yml')
  namespace :mysql do
    config = YAML.load(File.read(Rails.root.join('config/database.yml')))[Rails.env.to_s]
    db = config['database']
    host = config['host']
    FileUtils.mkdir_p Rails.root.join('mysql')

    backup = "mysqldump -h #{host} #{db} > #{Rails.root}/mysql/dump.sql"
    desc backup
    task :dump do
      zfben_rails_rake_system backup
    end

    restore = "mysql -h #{host} #{db} < #{Rails.root}/mysql/dump.sql"
    desc restore
    task :restore => 'db:create' do
      zfben_rails_rake_system restore
    end

    backup_all = "mysqldump -h #{host} --all-databases > #{Rails.root}/mysql/dump_all.sql"
    desc backup_all
    task :dump_all do
      zfben_rails_rake_system backup_all
    end

    restore_all = "mysql -h #{host} < #{Rails.root}/mysql/dump_all.sql"
    desc restore_all
    task :restore_all => 'db:create' do
      zfben_rails_rake_system restore_all
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
h2ocube_rails_tasks-0.0.7	lib/h2ocube_rails_tasks/tasks/mysql.rb
h2ocube_rails_tasks-0.0.6	lib/h2ocube_rails_tasks/tasks/mysql.rb
h2ocube_rails_tasks-0.0.5	lib/h2ocube_rails_tasks/tasks/mysql.rb