Building Drupal Multisite on MWN Web Hosting

As web designer and developer I trust MWN to serve hosting for my client's websites. To install Drupal multisite on MWN that based on SPanel, below are the tutorial I have to you:

I. Using subdomain for Drupal multisite
1. Create your initial Drupal site at www.yourdomain.com.
2. Create a folder in the sites/ folder that matches the subdomain you want to create (so for site1.yourdomain.com, the folder name would be site1.yourdomain.com).
3. Duplicate the settings.php file from the default folder and place it in your newly created folder from step 2.
4. Edit the settings.php file you just placed in the site1.yourdomain.com folder so that it does not point to a database. You can replace the line that has your other site's database information with this:
$db_url='mysql://username:password@localhost/databasename';

The alternative to setting up a separate database for each multisite installation is to assign all sites to the same database as the primary domain, but with their own table prefixes. So for example, for the users table you would have:
Multisite database:
database1.site1.users database2.site2.users database3.site3.users
Single database:
database1.site1_users database1.site2_users database1.site3_users

5. In SPanel (www.yourdomain.com/spanel/spanel.cgi), setup the subdomain from Subdomain Manager menu then click add subdomain. For the above example of site1.yourdomain.com, fill "site1" (without the quotation mark) in the column right before your primary domain. And CHOOSE Alias then click Add.
6. Go to your subdomain address and type in your browser: site1.yourdomain.com/install.php. Drupal will ask for your database information and then install the table necessary to run the new site.
7. You are all set to use a new Drupal multisite in your subdomain.


II. Using domain parking for Drupal multisite
1. Create your initial Drupal site at www.yourdomain.com.
2. Create a folder in the sites/ folder that matches the parked domain you want to create (so for www.yourdomain2.com, the folder name would be yourdomain2.com).
3. Duplicate the settings.php file from the default folder and place it in your newly created folder from step 2.
4. Edit the settings.php file you just placed in the yourdomain2.com folder so that it does not point to a database. You can replace the line that has your other site's database information with this:
$db_url='mysql://username:password@localhost/databasename';

The alternative to setting up a separate database for each multisite installation is to assign all sites to the same database as the primary domain, but with their own table prefixes. So for example, for the users table you would have:
Multisite database:
database1.site1.users database2.site2.users database3.site3.users
Single database:
database1.site1_users database1.site2_users database1.site3_users

5. From your primary domain SPanel (www.yourdomain.com/spanel/spanel.cgi), go to Domain & DNS Manager menu then click Add Addon Domain. Fill your parked domain (www.yourdomain2.com) on Domain's field and choose "addon" for Template zone DNS option then click Submit Query.
6. Setting up the symlinks by point your SSH client at your primary domain and login (I used PuTTY in SSH mode on my Window XP or you can use your own terminal on *NIX machines).
7. At the command line prompt, type each line then hit Enter:

cd /u/your_username/sites
rm -Rf ./yourdomain2.com
ln -s . yourdomain2.com

The symlinks "yourdomain2.com" now points to your document root.
8. Go to your parked domain address and type in your browser
www.yourdomain2.com/install.php. Drupal will ask for your database information and then install the table necessary to run the new site.
9. You are all set to use a new Drupal multisite in your parked domain.