want to use multiple database.

[eluser]louisl[/eluser]
Check in the index.php for the ENVIRONMENT constant, I think that was added in 2.0.1
Then just switch your ./application/config/database.php depending on the environment eg.

Code:

switch (ENVIRONMENT) {

case 'development' :

  $db['default']['username'] = 'xxx';
  $db['default']['password'] = 'xxx';
  $db['default']['database'] = 'xxx';
  
break;

case 'testing' :
case 'production' :

  $db['default']['username'] = 'yyy';
  $db['default']['password'] = 'yyy';
  $db['default']['database'] = 'yyy';
  
break;

default:

  exit('The application environment is not set correctly.');
  
break;

}