Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
manoe
Client


Joined: Aug 14, 2005
Posts: 151

PostPosted: Sat Apr 19, 2008 12:51 am Reply with quote

I was supplied a link from Raven for the steps to do this but I have a few things that I need to clarify first.
Only registered users can see links on this board! Get registered or login!

3.7.1.1 question - Had both config.php files opened and I copied the sql database info for the current main site into the config.php of the new subDomain RN install. I assume (based of the link above) that this is correct. The only edit I made to the sql info was adding the 1 and 2 for the first and second website.

Is this correct? I have not done anything to the existing nuke.sql yet because I want to know the exact process before I commit to possibly trashing my database Smile

Do I edit these config.php files THEN the nuke.sql THEN install the RavenNuke package for the second site? Its all on my FTP, I just need to go thru the install process BUT this is where I had questions. I shouldnt have to do the usual sql install stuff because I am using the existing database correct? The config.php should already have the needed info in it for the site to work?
 
View user's profile Send private message
jakec
Site Admin


Joined: Feb 06, 2006
Posts: 3048
Location: United Kingdom

PostPosted: Sat Apr 19, 2008 3:42 am Reply with quote

OK, just to clarify can you confirm exactly what you are doing?

1. Are you trying to install two sites in the same database, but with separate data?

2. Installing two sites with separate content, but sharing the users?

3. Installing two sites with the same data and users?

From your title it sounds like you want to do option 3, but 3.7.1.1 refers to option 1.
 
View user's profile Send private message
manoe
PostPosted: Sat Apr 19, 2008 7:59 am Reply with quote

2 sites, seperate content but sharing users.

awolgamers.com site1

aoc/awolgamers.com site2

For some reason I thought that you had to do both??
 
manoe
PostPosted: Sat Apr 19, 2008 5:01 pm Reply with quote

ok I am in the land of the unknown. I went into my assault_nuke database in phpMyAdmin and I have not a clue as to what I am looking at. I am directed to edit nuke.sql files so that my 2 sites will share users.

I am really lost. I have the config.php files ready I believe. That part seemed easy but I still have not uploaded them to the server. A point of serious confusion for me is the fact that it says that "the full name of the users table should thus be "nuke-common_users" in both nuke.sql files. Then proceed with the installation as described".

Now, it talks about setting up the user tables in both sites ... Only 1 site is installed. The new one just has the RavenNuke install files in its root folder. So I am of course getting really confused. Any of Ravens forum admins here willing to set this up for me? We would be willing to pay.
 
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Sat Apr 19, 2008 6:57 pm Reply with quote

You will need to run the install to set up two sets of tables (with different prefixes).

Then you will need to set the user_prefix values the same, to point to one of the users tables (either one will do).

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
manoe
PostPosted: Sat Apr 19, 2008 7:47 pm Reply with quote

but I am sharing the database and users. The second install has to have its own tables? argh. lol

so..

before I do ANYTHING I edit the config.php to share the database then I install the sub site. AFTER that I go about editing the sql stuff?

heh Raven is to busy to do this for a fee so I need to be pointed to someone that does this stuff for kaching!. I am 100% still lost.. probably worse than 2 hours ago.
 
manoe
PostPosted: Sat Apr 19, 2008 10:36 pm Reply with quote

well I have an existing website already so I will not be installing 2 sets of tables. I am going to use that sites users for the new sub site for my main. So I dont see how you telling me to install 2 sets of tables makes this less confusing for me Smile I would only need to install the NEW nuke site and its tables? The go back and edit them so that they use the same stuff? Or do I simply enter the info from the current website into the config.php for the NEW website then run the installer? Anyone?
 
evaders99
PostPosted: Sun Apr 20, 2008 3:19 am Reply with quote

You need two sets of tables, otherwise both your sites will be serving up exactly the same content. Load the tables first before doing any changes to config.php

You can enter the same information from config.php, but the prefix value must be different.
 
manoe
PostPosted: Sun Apr 20, 2008 11:18 am Reply with quote

That makes sense now. Thanks for the clarification!
 
sting
Involved
Involved


Joined: Sep 23, 2003
Posts: 456
Location: Somewhere out there...

PostPosted: Wed Apr 23, 2008 9:00 am Reply with quote

Out of cursiosity - has anyone messed with replication in MySql that can speak intelligently on the subject? (Does MySql even provide the option for replication?)

_________________
You see - I told you I wasn't paranoid. They were really out to get me. 
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Wed Apr 23, 2008 11:05 am Reply with quote

May want to try the mysql forum for that one to keep this one on topic? Smile
 
View user's profile Send private message Send e-mail
evaders99
PostPosted: Wed Apr 23, 2008 8:39 pm Reply with quote

Mysql does provide replication, but I haven't tried it myself
 
sting
PostPosted: Thu Apr 24, 2008 1:17 pm Reply with quote

Guardian2003 wrote:
May want to try the mysql forum for that one to keep this one on topic? Smile


Hey, it's close enough! Laughing If MySql would do the replication, you could ~conceivably~ set up one databases' user table to replicate to the other. . . of course the timing of replication would be an issue, but it could work.

You would certainly answer the question "who's the biggest massochist" in the forums.

-sting
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Fri Apr 25, 2008 11:52 am Reply with quote

Not sure if you can do table-wise replication. It might be at a higher level than that. However, within the same database, one can certainly drop and recreate a new table based upon another one... Wink

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©