By sunitha-1 on

After changing the db_prefix in settins.php, wat should be done for the change to take effect in db?

⋅ Categories: Drupal 5.x

Comments

ChangeMachine’s picture

ChangeMachine commented

That depends on what you'd like to do. Here's a good explanation for setting up prefixes for a multisite:

http://drupal.org/node/147828

citizen Vern
; )

sunitha-1’s picture

sunitha-1 commented

thanku for ur favor :)

shakethetv’s picture

shakethetv commented

//////////////// sites/default/setting.php sample ///////////

///main website

$db_name = main_;
$db_shared = db_shared_;
$db_prefix = array(
'default' => db_main_,
'access' => db_shared_,
'filters' => db_shared_,
'filter_formats' => db_shared_,
'permission' => db_shared_,
'role' => db_shared_,
'sequences' => db_shared_,
'sessions' => db_shared_,
'users' => db_shared_,
);

//////second website shared

$db_name = db_comedy_;
$db_shared = db_shared_;
$db_prefix = array(
'default' => db_comedy_,
'access' => db_shared_,
'filters' => db_shared_,
'filter_formats' => db_shared_,
'permission' => db_shared_,
'role' => db_shared_,
'sequences' => db_shared_,
'sessions' => db_shared_,
'users' => db_shared_,
);

//////////// apache httpd.conf sample ///////////////

NameVirtualHost 127.0.0.1

<VirtualHost 127.0.0.1>
    DocumentRoot E:/multisite/multisite1
    ServerName monsite.com
    ServerAlias www.monsite.com
</VirtualHost>
 <Directory E:/multisite/multisite1>
   RewriteEngine on
   RewriteBase /
   RewriteCond %{REQUEST_FILENAME} !-f
   RewriteCond %{REQUEST_FILENAME} !-d
   RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]
</Directory>
<VirtualHost 127.0.0.1>
    DocumentRoot E:/multisite/multisite2
    ServerName comedy.monsite.com
    ServerAlias comedy
    ServerPath /multisite2/

</VirtualHost>
 <Directory E:/multisite/multisite2>
   RewriteEngine on
   RewriteBase /
   RewriteCond %{REQUEST_FILENAME} !-f
   RewriteCond %{REQUEST_FILENAME} !-d
   RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]
</Directory>

shakethetv.com - lyrics - music