[drupal-support] New sites and db prefixes

[Tib]

Ack - although I found you also need to edit the insert commands to
reflect the new prefix too. D'oh!

<EOL>
Tib

On Sun, 19 Jun 2005, Tib wrote:

>
Excellent - this is exactly what I needed to see. I knew it could do it (I
mean come on - that seemed like the whole point of it actually) but there
didn't seem to be any method provided with drupal for doing so.

Thanks!

<EOL>
Tib

On Sun, 19 Jun 2005, Christopher Taylor wrote:

> Hi,

I am working on a similar issue.
In order for you to create a second site in the same database.
You have to create the tables which you refer to in your settings.php file.
So, you can take the database.mysql file, replace all instructions by adding
the prefix and then importing the file.
For example:
CREATE TABLE access
should be replaced with
CREATE TABLE dr_access
Then, you import the file.
Some have suggested using two databases.
Drupal is supposed to be easily used by the end user.  This is not possible.
I have struggled so hard to make it do what I want it to do.
Clearly, this is because I have no knowledge of PHP.
If I did, this would be a great and  powerful platform.

I hope this helps.

Regards


----- Original Message -----
From: "Tib" <tib at tigerknight.org>
To: <drupal-support at drupal.org>
Sent: Sunday, June 19, 2005 4:17 PM
Subject: [drupal-support] New sites and db prefixes


>
> Ok - so I have my first site, which has no prefix.. now how do I add
> another site with it's own prefix? I've extracted the drupal files into a
> new folder, verified that it has access to modrewrite, and configured the
> sites/default/settings.php to have a prefix of my choosing, and setup the
> .htaccess properly. But when I go to the web page it errors out telling me
> the tablespace for my prefix doesn't exist.
>
> The handbook doesn't really cover this that I could find. Hopefully I'm
> just reading too fast and missing something obvious..?
>
> <EOL>
> Tib
> --
> [ Drupal support list | http://lists.drupal.org/ ]

-- 
[ Drupal support list | http://lists.drupal.org/ ]
-- 
[ Drupal support list | http://lists.drupal.org/ ]