Contents

namespace :db do
  namespace :config do
    desc "Create shared/config/database.yml"
    task :setup do
      puts "\n ** == Configuring config/database.yml (mysql) ...\n\n"
      prompt_with_default("Database name", :db_name, "#{application}_#{stage}")
      prompt_with_default("Database username", :db_username, "#{application}_#{stage}")
      prompt_with_default("Database password", :db_password)
      prompt_with_default("Database host", :db_host, "localhost")
      prompt_with_default("Database port", :db_port, "3306")
      database_yml = <<-EOF
production:
  adapter: mysql
  encoding: utf8
  database: #{db_name}
  username: #{db_username}
  password: #{db_password}
  host:     #{db_host}
  port:     #{db_port}
  pool:     10
  timeout:  5
EOF
    put database_yml, "#{shared_path}/config/database.yml"
    end
  end

  desc "Download production database to local machine"
  task :pull do
    prompt_with_default("Database name", :database_name, "#{application}_#{stage}")
    prompt_with_default("Local role", :local_role, "root")
    prompt_with_default("Overwrite local development db? (y/n)", :overwrite, "y")

    # Dump database
    sudo "mysqldump #{database_name} > /tmp/db_dump.sql", :hosts => first_db_host
    # Download dumped database
    get_with_status "/tmp/db_dump.sql", "tmp/#{application}_#{stage}_dump.sql", :via => :scp, :hosts => first_db_host
    # Delete dumped database from server
    sudo "rm -rf /tmp/dump.sql", :hosts => first_db_host
    if overwrite.to_s.downcase[0,1] == "y"
      # Import data
      system "mysql -u #{local_role} #{application}_development < tmp/#{application}_#{stage}_dump.sql"
    end
  end
end

Version data entries

21 entries across 21 versions & 1 rubygems

Version	Path
crossroads_capistrano-1.4.25	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.24	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.23	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.22	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.21	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.20	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.19	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.18	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.17	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.16	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.15	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.14	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.13	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.12	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.11	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.10	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.9	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.8	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.7	lib/crossroads_capistrano/recipes/mysql.rb
crossroads_capistrano-1.4.6	lib/crossroads_capistrano/recipes/mysql.rb