[eluser]larsonator[/eluser]
Hi,
while i have not used table prefixes myself, it looks as though you should be ok with using two Database configurations. Each with the same connections strings, but with different db_prefixes.
Eg.
Code:
$active_group = 'edu'
$active_record = TRUE;
$db['edu']['hostname'] = DB_HOST;
$db['edu']['username'] = DB_USER;
$db['edu']['password'] = DB_PASS;
$db['edu']['database'] = DB_PRIMARY;
$db['edu']['dbdriver'] = 'mysql';
$db['edu']['dbprefix'] = 'edu_';
$db['ext']['hostname'] = DB_HOST;
$db['ext']['username'] = DB_USER;
$db['ext']['password'] = DB_PASS;
$db['ext']['database'] = DB_PRIMARY;
$db['ext']['dbdriver'] = 'mysql';
$db['ext']['dbprefix'] = 'ext_';
you can load the databases like so:
Code:
$this->load->database('ext', true);
$this->load->database('edu', true);
Correct me if there is a better way of doing so by all means, but thats one way i see it being done.