[typo] db:create gives "Unknown database"

[Arun Gupta]

> First you need to modify the database.yml so it has permission to access
> typo_dev typo_tests or typo.
>
> If  you want to run with root that's fine.
Yep, that's fine with me since first I want to get the feel of Typo.

>
> at a shell prompt type,
>
> mysqladmin create typo
> mysqladmin create typo_dev
> mysqladmin create typo_tests
>
> then you can try rake db:create
I know mysqladmin command.

AIU the main point of db:create is to create the database. Since Rails
2.0, I've never use mysqladmin command to create the database and
always used db:create. I'm still confused why I need to explicitly
create the database using mysqladmin.

-Arun

>
> On May 29, 2008, at 5:49 PM, Arun Gupta wrote:
>
>>> Okay this is plain silly,
>>
>> Sorry, but not working for me :(
>>
>>>
>>> what does your config/database.yml show?
>>
>> It is the one bundled with Typoe 5.0.3 and shown here:
>>
>> login: &login
>>  adapter: mysql
>>  host: localhost
>>  username: root
>>  password:
>>
>>
>> development:
>>  database: typo_dev
>>  <<: *login
>>
>> test:
>>  database: typo_tests
>>  <<: *login
>>
>> production:
>>  database: typo
>>  <<: *login
>>
>>>
>>> Which Adapter are you using SQLite3? MySQL?
>>
>> MySQL with JRuby
>>
>>>
>>> If you are using MySQL please create the database, db:create does not
>>> create
>>> the database for you.
>>
>> Hmmm ...
>>
>> ~/testbed/jruby-1.1.2/bin/jruby -S rails foo -d mysql
>> cd foo
>> ~/testbed/jruby-1.1.2/bin/jruby -S rake db:create
>>
>> http://dev.rubyonrails.org/changeset/6849 also says so.
>>
>> What am I missing ?
>>
>> -Arun
>>
>>
>> --
>> Web Technologies and Standards
>> Sun Microsystems, Inc.
>> Blog: http://blogs.sun.com/arungupta
>>
>> !DSPAM:483f4f4c110161263019146!
>>
>>
>
>



-- 
Web Technologies and Standards
Sun Microsystems, Inc.
Blog: http://blogs.sun.com/arungupta