config<\/span> =<\/span> Rails<\/span>::<\/span>Configuration<\/span>.<\/span>new<\/span><\/div>database<\/span> =<\/span> config<\/span>.<\/span>database_configuration<\/span>[<\/span>RAILS_ENV<\/span>][<\/span>"database"<\/span>]<\/span><\/div>username<\/span> =<\/span> config<\/span>.<\/span>database_configuration<\/span>[<\/span>RAILS_ENV<\/span>][<\/span>"username"<\/span>]<\/span><\/div>password<\/span> =<\/span> config<\/span>.<\/span>database_configuration<\/span>[<\/span>RAILS_ENV<\/span>][<\/span>"password"<\/span>]<\/span><\/div> <\/div>
namespace<\/span> :db<\/span> do<\/span><\/div> <\/div>
#rake db:dump<\/span><\/div> desc<\/span> "dumps the database to a sql file"<\/span><\/div> task<\/span> :dump<\/span> =><\/span> :environment<\/span> do<\/span><\/div> puts<\/span> "Creating <\/span>#{<\/span>database<\/span>}<\/span>_dump.sql file."<\/span><\/div> `mysqldump -u "<\/span>#{<\/span>username<\/span>}<\/span>" --password="<\/span>#{<\/span>password<\/span>}<\/span>" "<\/span>#{<\/span>database<\/span>}<\/span>" > "<\/span>#{<\/span>database<\/span>}<\/span>"_dump.sql`<\/span><\/div> end<\/span><\/div> <\/div>
#rake db:dumpimport - Resets the DB.<\/span><\/div> desc<\/span> "imports the <\/span>#{<\/span>database<\/span>}<\/span>_dump.sql file to the current db"<\/span><\/div> task<\/span> :dumpimport<\/span> =><\/span> [<\/span>:environment<\/span>,<\/span> :reset<\/span>]<\/span> do<\/span><\/div> `mysql -u root --password="<\/span>#{<\/span>password<\/span>}<\/span>" "<\/span>#{<\/span>database<\/span>}<\/span>" < "<\/span>#{<\/span>database<\/span>}<\/span>"_dump.sql`<\/span><\/div> end<\/span><\/div> <\/div>
end<\/span><\/div><\/pre><\/div>\n \n <\/div>\n\n