[drupal-support] multiple sites

[Christopher Taylor]

Hello,
I am very sorry to bother everybody.

I am trying to import a dump I made of the database to run multiple sites
from the same code and database.  I changed the prefix on the tables to ci_
from br_.
Now, it acknowedges by saying "6731 instructions inserted".  But, nothing
but the original 84 dr_ tables show up.
Also, I have a constant error of:

PMA Database ... not OK[

A. I exported the table with only "data" and "structure" boxes checked.
B. Then, I changed the prefix to ci_ from dr_.
C. Then I went to import files and did a import on the file name I made the
changes on.
D. It acknowledges success but it doesn't show up in the list of tables.

Any thoughts.

Regards

----- Original Message ----- 
From: "William Meertens" <nuke at meewi.be>
To: <drupal-support at drupal.org>
Sent: Thursday, June 16, 2005 6:55 AM
Subject: Re: [drupal-support] multiple sites


> Hi there,
>
> Let's try and put it different :
>
> 1st major rule and concern. IS YOUR SECOND DOMAIN ** POINTING ** AT THE
FIRST DOMAIN ?
>
> In many cases a normal sub-domain is pointing to a different directory on
your server. And therefor not able to reach your Drupal installation. A real
(not sub) domain has to have the same DNS and needs to be pointed at the
other domain by your server. Not only changing the DNS you need to change
your server or domain values as well. Otherwise this domain ends up in a
different location as well on your server.
>
> I just started two weeks ago with Drupal. And must say this went with me
like a charm. 7 top level domains and 4 sub-domains are running with one
Drupal installation and on 2 mysql databases. The install was as simple as
copy and paste the guide in the handbook, with changing the domainnames ;-)
>
> In your case I suggest :
> sites/ci.example.com
> But be aware your sub-domain installation points that domain to :
> /ci.example.com
> if your hosting uses Cpanel, or
> /subdomains/ci.example.com
> if your hosting uses Plesk
> So you really need to look into that before you go any further.
>
> Probably it's one of these two if you did all the rest like it's explained
here before and like mentioned in the Handbook.
> http://drupal.org/node/258
>
> Good luck,
> William.
>
> On Wed, 15 Jun 2005 18:23:29 -0400
> "Christopher Taylor" <christ at bnmc.com> wrote Re: [drupal-support] multiple
> sites :
>
> > Hi,
> > I did all the steps.
> > I aded a sub-directory of "ci" under sites with a settings.php.
> > I aded the settings.php file.
> > I can't pull it up.
> > Does this make the site address
> > ci.example.com or example.com/ci.
> > How do you set this?
> > Sorry, I tried to read the example help text and I just can't make sense
of
> > it with my speech system.
> >
> > Regards
> >
> >
> >
> > ----- Original Message ----- 
> > From: "Ross Kendall" <drupal at rosskendall.com>
> > To: <drupal-support at drupal.org>
> > Sent: Wednesday, June 15, 2005 6:11 PM
> > Subject: Re: [drupal-support] multiple sites
> >
> >
> > > Hi Christopher,
> > >
> > > Your list looks right to me, the best thing is to give it a try.
> > >
> > > There are a couple of scripts to help with adding the prefix onto
table
> > > names in database.mysql (and add on module .mysql files), look for
> > > 'prefix.sh' under scripts.  I also wrote a script in perl to do the
same
> > > (why I don't know).
> > >
> > > If you can set up more than one database on your webserver (for
example,
> > > one for each site), this is a simpler way to do things than having
table
> > > prefixes (unless of course you would like to share some database
tables
> > > between sites).  Just edit each settings.php file with the appropriate
> > > database settings.
> > >
> > > What you probably want to ask yourself is:
> > >  *What do I want to share (or not share) between the multiple sites?*
> > >  - database
> > >  - directory structure (main drupal codebase)
> > >  - modules
> > >  - content
> > >  - users
> > > etc.
> > >
> > > Drupal can handle sharing various things between sites, in different
> > > ways.  So stop and think about exactly what you are trying to achieve
> > > first, then work out how to do it.
> > >
> > > Hope that helps,
> > > Ross.
> > >
> > > Christopher Taylor wrote:
> > >
> > > >Greetings-
> > > >
> > > >Sorry, it is still a little foggy for me.
> > > >Is the following steps going to give me a second fully functioning
site?
> > > >A. Change prefixes in the database.mysql file to ba_.
> > > >B. Import tables into database with PHP My Admin using
database.mysql.
> > > >C. Create sub directory with the settings.php file in sites
directory.
> > > >D. set the $db_prefix in settings.php.
> > > >
> > > >Is this right or is there another way?
> > > >
> > > >Thank you.
> > > >Regards
> > > >
> > > >
> > > >
> > > >
> > > -- 
> > > [ Drupal support list | http://lists.drupal.org/ ]
> >
>
>
> -- 
>                            \|/ ____ \|/    _     _             `  _  '
>                  ////       @~/ ,. \~@   o' \,=./ `o          -  (_)  -
>                 (o -)      /_( \__/ )_\     (o o)               '   `
> +-----------ooO--(_)--Ooo-----\__U_/----ooO--(_)--Ooo------------------+
> http://www.meewi.be                                       SMILE
> http://www.ladiescycling.net                       it cost nothing and
> http://www.hostinglc.net                           it's beyond price !
> ------------------------------------------------------------------------
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]