hi , I have started to learn ruby on rails and I'm an absolute beginner . when I try to rake a database like "rake db:schema:dump " I get this message : "rake aborted ! unknown database 'cms_development' " although I have modified my database.yml and have created my database before. I'll be appreciated if someone can help me with this thanks
To confirm that the DB in question exists: can you access it directly from the console, using the same name/username/password that's in config/database.yml ?
yes I can access it with the username and password in database.yml without any problem
OK, do you have the same rake problem with test and production DBs?
You might also want to tell us what versions of Ruby and Rails you're using and which DB server.
Can you post database.yml and tell us exactly what command(s) you use to show that a database of that name does exist.
Colin
I haven't tested 'test' and 'production' and I have 3.0.9 version of ruby on rails and working with mysql
this is my database.yml content:
# MySQL. Versions 4.1 and 5.0 are recommended.
Are you *absolutely* sure it is spelt right? copy/paste the output of show databases just to keep us happy. I presume that database.yml above was copied and pasted here.
Colin
So, why not? That would provide a couple more data points.
Problem Determination 101...
Hi,
Please check if you have all necessary gems too. Copy/paste here the output pls. $ gem list
Comments says: # gem install mysql2 -> if mysql2 gem is missing this is the point. You needn't use "gem install" because "bundle install" will take care of all gem dependencies.
One way to detect if your DB connection is the problem: - first check from console (as you did) - then test with another type of DB. Mostly if you're new in Rails then use just with default settings with SQLite3. It also requires the gem installed. If it works with SQLite3 then your DB settings or MySQL username/pw has problems. If not then then other (probably gem if you haven't modified much yet).
Colin's also right, please check your spelling one more time and copy/ paste here.
If you have struggles with starting contact me in private, good luck, Gezope