rake db:migrate - where is my table?

rubyonrails-talk
1

Not sure if this is another rails 2.0 issue and the info in AWDWR 2nd ed, or not...

(I'm new to Rails) I modified the 001_create_products.rb file and added the needed info to create 3 tables in a database that I created using CocoaMySQL. When I ran "rake db:migrate" the info on the console looked good. I then go into CocoaMySQL, select that same database, but there are no tables in it. Any ideas? I also use mysql on the command line to look at that database, but no table to be found. What up with that?

Thanks.

2

What's the result of:

rake db:migrate VERSION=0 --trace

-Thufir

3

Pardon, I don't follow your point. Yes, I'm all for thread continuity :slight_smile:

-Thufir

4

Not sure if this is another rails 2.0 issue and the info in AWDWR 2nd ed, or not...

(I'm new to Rails) I modified the 001_create_products.rb file and added the needed info to create 3 tables in a database that I created using CocoaMySQL.

Had you already migrated using this migration before you modified it? This is the picture I get from saying you modified it rather than creating it.

> When I ran "rake db:migrate" the info on the console

looked good. I then go into CocoaMySQL, select that same database, but there are no tables in it. Any ideas? I also use mysql on the command line to look at that database, but no table to be found. What up with that?

If you really did modify it, then rake db:migrate probably didn't do anything other than get the current schema version from the database, notice that it was already 1, and quit.

In general you want to generate a new migration each time you make a schema change to the database.