<![CDATA[Rails Forum - Ruby on Rails Help and Discussion Forum - DANGER: rake db:migrate drops the entire database. How to avoid this?]]> http://railsforum.com/viewtopic.php?id=51551 Mon, 10 Dec 2012 16:51:27 +0000 PunBB <![CDATA[Re: DANGER: rake db:migrate drops the entire database. How to avoid this?]]> http://railsforum.com/viewtopic.php?pid=157462#p157462 It never happened to me
rake db:migrate is to run all the tasks which is under the directory db/migrations to make your database schema up_to_date, which is  not supposed to delete your existing database.

]]> Mon, 10 Dec 2012 16:51:27 +0000 http://railsforum.com/viewtopic.php?pid=157462#p157462 <![CDATA[DANGER: rake db:migrate drops the entire database. How to avoid this?]]> http://railsforum.com/viewtopic.php?pid=157453#p157453 I had a legacy rails app which is working fine against a database.
I am building a new rails app which is aimed at replacing eventually the old legacy app. It runs against the same database.
When I first created the new rails app, I created a first migration to add a new table.
I ran rake db:migrate, and it deleted the entire database with its tens of thousands of records! Thanks god it was in dev environment. And thank god, I managed to restore this entire database (I copied all the migrations from the legacy app to the new app) and reran the entire migrations from scratch.

Now I would like to put my new app in a production environment. How can I run a new migration in production without deleting the entire production database, but just incrementally run the last migration on top of the existing database?

Is there an option, a parameter to pass to the rake db:migrate command to prevent it from deleting the existing database?

]]> Mon, 10 Dec 2012 13:09:59 +0000 http://railsforum.com/viewtopic.php?pid=157453#p157453