multiple database connection..

hai...friends..      how to create multiple mysql database ??pls help i ve used the following type but it creates only one database mobile_development..any help pls...

development:   adapter: mysql   database: mobile_development   timeout: 5000   username: root   password:   host: localhost environment_name1: adapter: mysql database: database1 username: root password: host: localhost

environment_name2: adapter: mysql database: database2 username: root password: host: localhost test:   adapter: mysql   database: mobile_test   timeout: 5000   username: root   password:   host: localhost

production:   adapter: mysql   database: mobile_production   timeout: 5000   username: root   password:   host: localhost

hai...friends..     how to create multiple mysql database ??pls help i ve used the following type but it creates only one database mobile_development..any help pls...

I don't know what you've done beyond edit database.yml, but at the
very least you're going to need to indent it properly: the
environment_name1 and environment_name2 entries you've added aren't
indented like the other ones.

Fred

thank u for ur kind reply.. development:   adapter: mysql   database: library_development   timeout: 5000   username: root   password:   host: localhost

test:   adapter: mysql   database: library_test   timeout: 5000   username: root   password:   host: localhost production:   adapter: mysql   database: library_production   timeout: 5000   username: root   password: its the normal way to connect a data base....how to connect two database or more like this ...any help pls..am a new one to ruby rails..

Jai Jai wrote:

hai...friends..      how to create multiple mysql database ??pls help i ve used the following type but it creates only one database mobile_development..any help pls...

development:   adapter: mysql   database: mobile_development   timeout: 5000   username: root   password:   host: localhost environment_name1: adapter: mysql database: database1 username: root password: host: localhost

Theoreticaly you can have every table in its own database, server.

class Mytable < ActiveRecord::Base   establish_connection(:environment_name1) end

or

class Mytable2 < ActiveRecord::Base   establish_connection(   :adapter => "mysql",   :host => "localhost",   :username => "root",   :password => "",   :database => "database2" )   set_table_name "anyname" end

set_table_name comes wery handy when pluralization is a problem.

by TheR

Theoreticaly you can have every table in its own database, server.

class Mytable < ActiveRecord::Base establish_connection(:environment_name1) end

In my case I have multiple tables in each db so I do something like this:

class FinancialConnection < ActiveRecord::Base   self.abstract_class = true   establish_connection("#{RAILS_ENV}_financials".to_sym) end

By doing that I can have a development_financials, test_financials, and production_financials DB and vary the connection for the environment. Further, by making this connection class an abstract ARec class I can use it as the superclass for all the financially related tables:

class Account < FinancialConnection end

class Journal < FinancialConnection end

etc

(Note: this relies on the fact that subclasses share the db connection of their superclass if they do not establish one of their own).