Using 2 websites with a single database?

neophite · Regular Joined: Sep 13, 2003 Posts: 56 Location: Virginia

Downloaded Raven's 7.3 customized distro and then installed 2 websites on my LOCALHOST server (Using Apachie2Triad software package) on windows XP

Here is the config.php info for each website:
Site1

dbname="nuke"
dbprefix="nuke"
dbuser="nuke"

Site2

dbname="nuke"
dbprefix="nuke1"
dbuser="nuke"

So I have established for each website to use database named "nuke"
data tables for website #1= "nuke"
data tables for website #2="nuke1"
user prefix="nuke" so that it can be shared between both websites.

I can't figure out how to get the database tables "nuke" for website #1 and database tables "nuke1" for website #2 in the same database.

The install script from website #1 created the db and wrote the tables with out an problem. From website #2 the install script replaced website #1 data.

Can this be done with the installer or am I going about this the wrong way?

Thanks in advance for any assistance..

Tao_Man · Involved Joined: Jul 15, 2004 Posts: 252 Location: OKC, OK

you probley just have to do a search and replace on the sql install file and replace nuke_ with nuke1_

neophite · Regular Joined: Sep 13, 2003 Posts: 56 Location: Virginia

Tao_Man wrote:

you probley just have to do a search and replace on the sql install file and replace nuke_ with nuke1_

I don't want to change them, I want both prefixes in the same database.

On my hosted website, If I use the CPanel, I am able to go into MySQL and import one database into another....hmmmmm

I think that I may do some MySQL document research on my localhost system and see how to access such a control feature in MySQL to accomplish the same thing... Idea

I sure wish there was an easier way, but anyway I think I may have come up with an approach to a solution.

Thanks for your feedback, it got me to do some thinking (which is a challenge for this "old" grey matter) Wink

Tao_Man · Involved Joined: Jul 15, 2004 Posts: 252 Location: OKC, OK

What I ment was to create the script once with the prefix set as nuke that edit the sql file and run it again with the prefix nuke1.

How are you creating the tables in your database?

neophite · Regular Joined: Sep 13, 2003 Posts: 56 Location: Virginia

Tao_Man wrote:

What I ment was to create the script once with the prefix set as nuke that edit the sql file and run it again with the prefix nuke1.

How are you creating the tables in your database?

I have been using the INSTALL that came in Raven's 7.3 Customized package..
I log in using my admin account from each website, at a time using the install script for the relavent website.

Each website config.php is setup up with to call the same database, using their pre-defined data table prefix nuke_ & nuke1_ respectfully.

There is NO option to add the tables to a database, ONLY create or REPLACE the database tables.

I need the install script modified to have the option to also ADD the data tables to a given database, this would really make the process easy for me (and others I would think).

Can this be done?

I hope that I have explained myself clearer Embarassed