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@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/ ]