I wanted to start with a fresh database, so I deleted my database, db_name_dev, and then recreated it. However, when I run rake db:migrate, instead of recreating my schema, I get this error:
Mysql::Error: Table 'db_name_dev.xxxx' doesn't exist: SHOW FIELDS FROM xxxx
This leads me to believe that somehow my app or MySQL doesn't know that I've started over, as it is looking for a table that will be recreated in my migration.
Why would it do that? I've gone through similar steps in the past (delete db, recreate, and run migrations) and have never seen this before. Does anyone know how I can force a fresh start so that I can use my migrations to rebuild my schema?
Thanks very much, Rohit