title: Rake db:migrate aborted! Ghost development database using MySQL2?
body: <p>OK, I just re-installed MySQL Servers 5.5(32bit to 64bit) on my Windows 7 64-bit machine. I then took the steps to use mysql2 for rails:</p>
  
  <pre><code>gem 'mysql2', '0.2.6'
  gem 'rails', '3.0.7'
  </code></pre>
  
  <p>Step 1: </p>
  
  <pre><code>rake db:drop
  Couldn't drop store_development : #&lt;Mysql2::Error: Unknown database 'store_development'&gt;
  </code></pre>
  
  <p>Strange because in the MySQL Workbench I only see the test database up.</p>
  
  <p>Step 2:</p>
  
  <pre><code>$ rake db:migrate
  rake aborted!
  Unknown database 'store_development'
  </code></pre>
  
  <p>No idea why I get this error so I try to reset the database now.</p>
  
  <p>Step 3:</p>
  
  <pre><code>rake db:reset
  (in C:/store)
  Couldn't drop store_development : #&lt;Mysql2::Error: Unknown database 'store_development'&gt;
  store_test already exists
  -- create_table("business_online_stores", {:force=&gt;true})
     -&gt; 0.1110s
  -- create_table("business_retail_stores", {:force=&gt;true})
     -&gt; 0.0740s
  -- create_table("businesses", {:force=&gt;true})
     -&gt; 0.0900s
  -- create_table("products", {:force=&gt;true})
     -&gt; 0.0810s
  -- create_table("user_prices", {:force=&gt;true})
     -&gt; 0.0720s
  -- create_table("users", {:force=&gt;true})
     -&gt; 0.1810s
  -- initialize_schema_migrations_table()
     -&gt; 0.2800s
  -- assume_migrated_upto_version(0, "db/migrate")
     -&gt; 0.0320s
  You have 6 pending migrations:
    20110909175650 DeviseCreateUsers
    20110929161120 CreateUserPrices
    20111004023516 CreateProducts
    20111007023521 CreateBusinesses
    20111009215120 CreateBusinessRetailStores
    20111009215419 CreateBusinessOnlineStores
  Run "rake db:migrate" to update your database then try again.
  </code></pre>
  
  <p>Yes, the Test database does already exist but where is this Ghost development database at? How does it reset the migrations, yet tell me to migrate them again. Ok, ill do as it says now:</p>
  
  <p>Step 4:</p>
  
  <pre><code>$ rake db:migrate
  (in C:/store)
  ==  DeviseCreateUsers: migrating ==============================================
  -- create_table(:users)
  rake aborted!
  An error has occurred, all later migrations canceled:
  
  Mysql2::Error: Table 'users' already exists: CREATE TABLE `users`
  </code></pre>
  
  <p>Step 5:</p>
  
  <pre><code>$ rake db:migrate
  rake aborted!
  Unknown database 'store_development'
  </code></pre>
  
  <p>Impossible, I went inside of my MySQL Workbench and dropped the test and development databases by right-clicking them and going through the necessary steps so nothing exist even when I refresh it, yet I get this error about a database that doesn't exist. </p>
  
  <p>How do I fix this problem?</p>
  
  <p>Note:  <code>0.2.7</code>  Gives me the same issues.</p>
  
  <p>Note: These are my first 2 migration files just encase anyone wanted to see them: <a href="https://gist.github.com/1341682" rel="nofollow">https://gist.github.com/1341682</a></p>