#43: resetting Rails schema_migrations table
Solved!on May 09, 2009, 02:04 AM UTC — from 
kueda ( 2,739 views )
kueda ( 2,739 views )
I just ran a failing migration, and in a fit of panic, deleted all the rows from my schema migrations table. That's a pretty dumb thing to do.
maybe there's a better way...
- kueda on May 09, 2009, 02:06 AM UTC
From the console...
Dir.open('db/migrate').each do |fname|
i = fname.split('_').first.to_i
next if i == 0
ActiveRecord::Base.connection.execute("INSERT INTO schema_migrations (version) VALUES(#{i})")
end