[drupal-support] multiple sites
William Meertens
nuke at meewi.be
Fri Jun 17 06:40:08 UTC 2005
Hi there,
> I am very sorry to bother everybody.
No bother, when we can help we do. Only I'm afraid you lost me and we can't follow anymore.
> 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.
You mentioned before that you use phpMyAdmin. So when you export everything and then change the table prefix with your favourite editor. After which you run it as an SQL you should end up with a database containing double the amount of tables in two different prefixes. At least that is how I did it. For me that was just work of three clicks. Find - change all - run. Normally phpMyAdmin gives you directly after a SQL run a result if it went good or bad. And you see the result directly in your left side listing of tables. If it does not show up, there must have been an error message coming from phpMyAdmin.
Or, perhaps... As I said before. I'm new to Drupal so I include here an old example. Keeping my tables safe ;-)
You should change in this case the prefix "nuke" and not "fx". What happens inside a table, you don't alter. Perhaps this is where you went wrong and all your altered tables are inside the other tables.
#
# Tabel structuur voor tabel `nuke_FormExpress`
#
CREATE TABLE `nuke_FormExpress` (
`fx_form_id` int(10) NOT NULL auto_increment,
`fx_form_name` varchar(50) NOT NULL default '',
`fx_description` text,
`fx_submit_action` text,
`fx_success_action` text,
`fx_failure_action` text,
`fx_onload_action` text,
`fx_validation_action` text,
`fx_active` tinyint(4) NOT NULL default '0',
`fx_language` varchar(30) NOT NULL default '',
`fx_input_name_suffix` varchar(30) NOT NULL default '',
PRIMARY KEY (`fx_form_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
Hope that was it. If not I relay start to believe we can't follow anymore.
Have fun,
William.
>
> 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/ ]
>
--
\|/ ____ \|/ _ _ ` _ '
//// @~/ ,. \~@ 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 !
------------------------------------------------------------------------
More information about the drupal-support
mailing list