Re: [support] Using two databases

On 12/12/06, Morbus Iff <morbus@disobey.com> wrote:

In the above code, where are you specifying the connection details for the new (second) database?

In my settings.php file, like this: $db_url['default'] = 'mysql://user:password@server/drupal'; $db_url['alt_db1'] = 'mysql://user:password@host1/database1'; $db_url['alt_db2'] = 'mysql://user:password@host2/database2'; The db_set_active() function seems smart enough to choose from the array, and the core DB layer seems smart enough to make the connection on the first query. IIRC. :-/ Am I missing something? My code works, but I wrote it a long time ago and haven't looked at it since.