title: Mysql2::Error: Table already exists
body: <p>I have some migrations that need to be run. But when I <code>rake db:migrate</code> the following error occurs.</p>
  
  <p><code>Mysql2::Error: Table already exists</code>. </p>
  
  <p>This happens for 4-5 times as the tables already exist but the <code>schema_migrations</code> table seems to be not in sync with the application.</p>
  
  <p>I have a production dump in my db and I don't want to drop tables and lose data. What I am currently doing is modifying the <code>schema_migrations</code> table and adding these conflicting migration numbers in there manually and then running <code>rake db:migrate</code> again until the errors go away and then my new migrations start to run. But that doesn't seem right.</p>
  
  <p>Is there any feasible solution to this other than what I mentioned which doesn't involve dropping the database or losing data? </p>