Lost my schema.rb! Can it be regenerated?

ruby-on-rails ruby-on-rails-3 git
brad picture brad · Mar 16, 2012 · Viewed 53.3k times · Source

Due to some deployment issues I stopped tracking schema.rb in git. Somehow I have stuffed this up and somewhere along the way my schema.rb file has disappeared.

Is there a way of regenerating schema.rb from the database or from the migrations? I would prefer not to lose the existing data.

Answer

mguymon picture mguymon · Mar 16, 2012

If you run a rake -T it will list all possible rake tasks for your Rails project. One of them is db:schema:dump which will recreate the schema.rb for the Rails app from the database.

bundle exec rake db:schema:dump

Related questions

GitLab email setup: sending via another mail server

By default gitlab has the next configuration in gitlab.yml : email: from: [email protected] host: gitlabhq.com but, I need to specify other variables (host, port, user, password, etc) to use another mail server. How I do that?

Read More
What is the best way to resolve Rails orphaned migrations?

I have been switching between branches in a project and each of them have different migrations... This is the scenario: $ rake db:migrate:status Status Migration ID Migration Name -------------------------------------------------- ... up 20130307154128 Change columns in traffic capture up 20130311155109 Remove log settings …

Read More
How to get a random number in Ruby

How do I generate a random number between 0 and n?

Read More