[support] Multiple site update and maintenance D6

[Earnie Boyd]

Quoting Ivan Sergio Borgonovo <mail at webthatworks.it>:

> On Sun, 29 Mar 2009 05:40:06 -0500
> "Cosmo" <drupallist at dirtsimple.net> wrote:
>
>> Nik,
>
>> The truth is, IMHO, keeping updated your Drupal site(s) is not for
>> the faint of heart. I use Drush all the time and it works well,
>> but still updates are tedious work.
>
> I just had to solve a problem that may offer some suggestions for
> further development.
>
> I've to do some "maintenance" to the DB supporting a multisite using
> prefix/schema/different db users in postgresql.
>
> I'm not aware of any way to loop through all "active" sites in a
> multisite.
> First, because I'm not aware of the concept of "active" site.
>

Crontab comes to mind using wget similar to cron.php.

Or perhaps a master control Drupal instance where the $db_url is an  
array of each sites DB.  Then you can run your foreach specifying each  
DB with db_set_active.

--
Earnie
-- http://r-feed.com/           -- http://for-my-kids.com/
-- http://www.4offer.biz/       -- http://give-me-an-offer.com/