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@tigerknight.org To: drupal-support@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/ ]