I posted a VERY rough draft here <a href="http://drupal.org/node/70861">http://drupal.org/node/70861</a><br>
<br>
Text copied below.<br>
PROBLEMS: Assumes that the user already has a main site
installed. Needs separate instructions for pgsql. Some
formatting issues. Sorta half between too detailed and
brief. Maybe separated into basic and very detailed would be
good... some people may appreciate knowing the whys and
wherefores, but some don't want to dig through all that.<br>
<br>
Good points: runs through examples of 3 basic alternate sub sites, sub domains, sub folders, and a completely separate domain.<br>
<br>
---------------------------------------<br>
<p>This document assumes the following:</p>
<ul>
<li>You want to create more than one Drupal site using the same
codebase (the same basic set of Drupal files, uploaded into one
location).
</li><li>You know how to install mysql tables in your database.
</li><li>You know how to set up subdomains/folders/other domains that you want to use.
</li><li>You have already downloaded Drupal 4.7, and set up one MAIN site.
</li>
</ul>
<p>This document contains instructions on how to create completely separate Drupal<br>
site, with different configurations, users and content. Nothing is shared between<br>
the installations except the codebase.</p>
<p>Some definitions:</p>
<p><strong>codebase:</strong> the basic set of Drupal files, included in the .tar.gz<br>
file. the stuff that makes Drupal work.</p>
<p><strong>database:</strong> a collection of <em>tables</em> that stores data.</p>
<p>Affected files:</p>
<p>settings.php (sites/default/...)</p>
<p>database.mysql</p>
<p>For this example, we will assume the following:</p>
<p><a href="http://www.example.com/" title="" rel="nofollow">www.example.com:</a> the MAIN site, where the codebase has already been uploaded,<br>
and settings.php has been properly configured.</p>
<p><a href="http://sub1.example.com">sub1.example.com</a>; <a href="http://www.example.com/sub2;" title="www.example.com/sub2;" rel="nofollow">www.example.com/sub2;</a> <a href="http://www.subexample.com/" title="www.subexample.com" rel="nofollow">
www.subexample.com</a> : the other sites<br>
we will create.</p>
<p>1. Create the following folders in your sites directory:</p>
<p>sites/sub1.example.com/</p>
<p>sites/www.example.com.sub2/</p>
<p>sites/www.sub3example.com/</p>
<p>Copy the settings.php file from sites/default into each of the above folders.</p>
<p>2. There are different database files (inside the database folder). Select<br>
the one that is appropriate for your database version. Copy it to each of the<br>
folders you made in step 1. This is OPTIONAL, but it will help you keep things<br>
straight.</p>
<p>3. Decide on SEPARATE PREFIXES for each site. Below is what we will use for<br>
the example:</p>
<p> <strong>site</strong><br>
<strong>database prefix</strong></p>
<p> <a href="http://sub1.example.com">sub1.example.com</a><br>
sub1_</p>
<p> <a href="http://www.example.com">www.example.com</a>,sub2<br>
sub2_</p>
<p> <a href="http://www.sub3example.com">www.sub3example.com</a><br>
sub3_</p>
<p>4. Configure your settings.php for each site.</p>
<p>This code MUST BE CHANGED FOR EACH SITE:</p>
<p>
</p>
<div class="codeblock"><code>$db_url = 'mysql://username:password@localhost/databasename';</code></div>
<p>Note; if you are using the same database as the MAIN site, the $db_url is the<br>
same.</p>
<p>OPTIONAL:</p>
<p><code># $base_url = '<a href="http://www.example.com">http://www.example.com</a>'; // NO trailing slash!</code></p>
<p>
</p>
<div class="codeblock"><code> # $conf = array(<br> # 'site_name' => 'My Drupal site',<br> # 'theme_default' => 'pushbutton',<br> # 'anonymous' => 'Visitor'<br> # );<br> </code></div>
<p>For <a href="http://sub1.example.com">sub1.example.com</a>, the settings would be:</p>
<div class="codeblock"><code>$db_prefix = 'sub1_';
</code><p>$base_url = '<a href="http://sub1.example.com">http://sub1.example.com</a>';</p>
<p>$conf = array(<br> 'site_name' => 'My SUB1 Drupal Site',<br> 'theme_default' => 'pushbutton',<br> 'anonymous' => 'Visitor'<br> );</p></div>
<p>For <a href="http://www.example.com/sub2" title="www.example.com/sub2" rel="nofollow">www.example.com/sub2</a>, the settings would be:</p>
<div class="codeblock"><code>$db_prefix = 'sub2_';
</code><p>$base_url = '<a href="http://www.example.com/sub2">http://www.example.com/sub2</a>';</p>
<p>$conf = array(<br> 'site_name' => 'My SUB2 Drupal Site',<br> 'theme_default' => 'fancy',<br> 'anonymous' => 'Anonymous'<br> );</p></div>
<p>For <a href="http://www.sub3example.com/" title="www.sub3example.com" rel="nofollow">www.sub3example.com</a>, the settings would be:</p>
<div class="codeblock"><code>$db_prefix = 'sub3_';
</code><p>$base_url = '<a href="http://www.sub3example.com">http://www.sub3example.com</a>';</p>
<p>$conf = array(<br> 'site_name' => 'My SUB3 Drupal Site',<br> 'theme_default' => 'marvin',<br> 'anonymous' => 'Guests'<br> );</p></div>
<p>6. Upload the modified settings.php files in their respective folders.</p>
<p>7. Open the database file you copied into each sites folder. Find the following (<b>don't forget the SPACE at the end!!!</b>):<br>
<code><br>
CREATE TABLE<br>
INSERT INTO<br>
</code></p>
<p>Replace each 'create table' and 'insert into' with 'create table dbprefix_' and 'insert into dbprefix_'</p>
<p>For <a href="http://sub1.example.com">sub1.example.com</a>:<br>
<code><br>
CREATE TABLE >> CREATE TABLE sub1_<br>
INSERT INTO >> INSERT INTO sub1_<br>
</code></p>
<p>8. Upload the modified mysql files into the database you specified in your settings.php.</p>
9. Voila!<br>
---------------------------------------<br clear="all"><br>
Let me know what you think! The style for this can be the basis for the other two basic configurations.<br>
<br>
Anisa.<br>
<br>-- <br>*********************************<br><a href="http://www.AnimeCards.Org">www.AnimeCards.Org</a><br><br>16,000 scans and counting!<br>*********************************