document.write("
\n"); document.write(" \n"); document.write(" \n"); document.write(" \n"); document.write("\n"); document.write(" \n"); document.write(" \n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write(" \n"); document.write("
\n"); document.write(" \n"); document.write(" \n"); document.write("
\n"); document.write(" \n"); document.write(" 
1\n");
document.write("2\n");
document.write("3\n");
document.write("4\n");
document.write("5\n");
document.write("6\n");
document.write("7\n");
document.write("8\n");
document.write("9\n");
document.write("10\n");
document.write("11\n");
document.write("12\n");
document.write("13\n");
document.write("14\n");
document.write("15\n");
document.write("16\n");
document.write("17\n");
document.write("18\n");
document.write("19\n");
document.write("20\n");
document.write("21\n");
document.write("22\n");
document.write("23\n");
document.write("24\n");
document.write("25\n");
document.write("26\n");
document.write("27\n");
document.write("28\n");
document.write("29\n");
document.write("30\n");
document.write("31\n");
document.write("<\/pre>\n");
document.write("			<\/td>\n");
document.write("
\n"); document.write(" 
namespace :db<\/span> do<\/span>\n");
document.write("  desc "Load production data into development database"<\/span>\n");
document.write("  task :load_production_data<\/span>, :roles<\/span> => :db<\/span>, :only<\/span> => { <\/span>:primary<\/span> => true<\/span> } do<\/span>\n");
document.write("    require<\/span> \'yaml\'<\/span><\/span>\n");
document.write("\n");
document.write("    # Gets db yml from server, because we don\'t store it on dev boxes!<\/span>\n");
document.write("    get "#{current_path}<\/span>/config/database.yml"<\/span>, "tmp/prod_database.yml"<\/span>\n");
document.write("    prod_config =<\/span> YAML<\/span>::load_file<\/span><\/span>(\'tmp/prod_database.yml\'<\/span>)\n");
document.write("    local_config =<\/span> YAML<\/span>::load_file<\/span><\/span>(\'config/database.yml\'<\/span>)\n");
document.write("\n");
document.write("    # Dump server sql<\/span>\n");
document.write("    filename =<\/span> "dump.#{Time<\/span>.now<\/span><\/span>.strftime<\/span><\/span> \'%Y-%m-%d_%H:%M:%S\'<\/span>}<\/span>.sql"<\/span>\n");
document.write("    server_dump_file =<\/span> "#{current_path}<\/span>/tmp/#{filename}<\/span>"<\/span>\n");
document.write("    on_rollback { <\/span>delete server_dump_file }\n");
document.write("    run "mysqldump -u #{prod_config[\'production\'<\/span>][\'username\'<\/span>]}<\/span> --password=#{prod_config[\'production\'<\/span>][\'password\'<\/span>]}<\/span> #{prod_config[\'production\'<\/span>][\'database\'<\/span>]}<\/span> > #{server_dump_file}<\/span>"<\/span> do <\/span>|channel<\/span>, stream<\/span>, data<\/span>|\n");
document.write("      puts data\n");
document.write("    end<\/span>\n");
document.write("\n");
document.write("    # Compress file for quicker transfer<\/span>\n");
document.write("    run "gzip #{server_dump_file}<\/span>"<\/span>\n");
document.write("    get "#{server_dump_file}<\/span>.gz"<\/span>, "tmp/#{filename}<\/span>.gz"<\/span>\n");
document.write("\n");
document.write("    puts "Uncompressing local db dump file"<\/span>\n");
document.write("    `gunzip tmp/#{filename}<\/span>.gz`<\/span>\n");
document.write("    puts "Loading locally..."<\/span>\n");
document.write("    `mysql -u #{local_config[\'development\'<\/span>][\'username\'<\/span>]}<\/span> --password=#{local_config[\'development\'<\/span>][\'password\'<\/span>]}<\/span> #{local_config[\'development\'<\/span>][\'database\'<\/span>]}<\/span> < tmp/#{filename}<\/span>`<\/span>\n");
document.write("    puts "Cleaning up temp files"<\/span>\n");
document.write("    `rm -f tmp/#{filename}<\/span>`<\/span>\n");
document.write("    `rm -f tmp/prod_database.yml`<\/span>\n");
document.write("  end<\/span>\n");
document.write("end<\/span>\n");
document.write("<\/pre><\/pre>\n");
document.write("		<\/td>\n");
document.write("		<\/tr>\n");
document.write("		<\/table>\n");
document.write("	\n");
document.write("	<\/div>\n");
document.write("\n");
document.write("\n");
document.write("  \n");
document.write("  \n");
document.write("  
\n");
document.write("    
\n");
document.write("      \n");
document.write("      <\/a>\n");
document.write("    <\/div>\n");
document.write("  \n");
document.write("    Pastie #335531<\/a> linked directly from Pastie<\/a>.\n");
document.write("  <\/div><\/div>");