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@meewi.be To: drupal-support@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.
Good luck, William.
On Wed, 15 Jun 2005 18:23:29 -0400 "Christopher Taylor" christ@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@rosskendall.com To: drupal-support@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/ ]