[eluser]InsiteFX[/eluser]
Hi,
you can setup your config database.php like this.
Code:
$active_group = "default";
$active_record = TRUE;
// LOCALHOST SITE DEFAULT.
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "username";
$db['default']['password'] = "password";
$db['default']['database'] = "cms";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_unicode_ci";
// LIVE SITE PRODUCTION.
$db['production']['hostname'] = "localhost";
$db['production']['username'] = "username";
$db['production']['password'] = "password";
$db['production']['database'] = "myotherdatabase";
$db['production']['dbdriver'] = "mysql";
$db['production']['dbprefix'] = "";
$db['production']['pconnect'] = TRUE;
$db['production']['db_debug'] = FALSE;
$db['production']['cache_on'] = FALSE;
$db['production']['cachedir'] = "";
$db['production']['char_set'] = "utf8";
$db['production']['dbcollat'] = "utf8_unicode_ci";
Change production to your other own name then you can load the one you want.
Enjoy
InsiteFX