Database not being selected in rails project when attempting to rake db:migrate

ruby-on-rails ruby-on-rails-3 migration rake mysql2
re5et picture re5et · Feb 6, 2011 · Viewed 8.6k times · Source

Working with a rails app, having some manner of weird database / rake issues.

When I execute:

rake db:migrate

I am getting the following error:

Mysql2::Error: No database selected: SHOW TABLES

(See full trace by running task with --trace)

The trace isn't revealing much useful information. Can be seen here: http://pastebin.com/WdsguudC

The config file looks right, and the user is getting logged in, or I would have gotten some kind of access error. The database exists, the user has correct permission, and I can access and manipulate it manually. I have done a bunch of googling, and haven't found anything helpful. Not sure if there is any other code that needs provided, because this seems like fairly low level problem.

Answer

re5et picture re5et · Feb 6, 2011

after all that it was a spacing issue in the yaml.

Related questions

Rails DB Migration - How To Drop a Table?

I added a table that I thought I was going to need, but now no longer plan on using it. How should I remove that table? I've already run migrations, so the table is in my database. I figure rails …

Read More
Rails: How can I rename a database column in a Ruby on Rails migration?

I wrongly named a column hased_password instead of hashed_password. How do I update the database schema, using migration to rename this column?

Read More
Change a column type from Date to DateTime during ROR migration

I need to change my column type from date to datetime for an app I am making. I don't care about the data as its still being developed. How can I do this?

Read More