If you use Drupal as a toolbox to implement a nice admin interface and your database administrator gets annoyed about the many tables Drupal uses, you can bracket your database code with calls to db_set_active(‘mydb’) like so:

db_set_active(‘mydb’);

// code that uses your existing database

db_set_active(‘default’);



	
In your sites/default/settings.php, you need to make $db_url an array like so:

$db_url = array(
  'default' => 'mysql://your:drupal@tables.live/here',
  'mydb' => 'mysql://all:your@other.tables.are/here',
);