Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How do I use 1 database for multiple DNN instal?How do I use 1 database for multiple DNN instal?
Previous
 
Next
New Post
5/5/2006 11:14 AM
 
Jay Mann

Joined: 5/1/2006
Posts: 9

I'm using webhots4life to host 3 sites.  For each of these sites, I'd like to install DNN on them.  Problem is, I only have 2 MS SQL database included in my hosting plan.  Can I use a prefix to identify the tables for each install so I can use the same database?  For example, site1_table1, site1_table2, site1_talble2, site2_table1, site2_table2, site2_table3, etc.  I know how to change table names in MS SQL Server, but what do I need to change in DNN for it to detect the new table names so nothing breaks?

 

Thanks.

 
 
New Post
5/5/2006 4:03 PM
 
Brian C



Joined: 2/8/2006
Posts: 92
One database will hold multiple 'websites' (portals in dnnspeak).  In wh4l you have the domains all pointing to the same directory on the server (ie. log in to your control panel, go to domains ... you should see all three of your domains).

Then install dotnetnuke (you can use their scripted install ... pretty easy though not totally foolproof).

Then visit your website using one of your domains.  It will automatically execute the scripts to build the database tables for a dotnetnuke installation.  If you get errors, contact wh4l tech support.  They'll get the initial installation set up.

Log in as host/host.  Change the password to something secure.  Visit host > portals.
Add a new portal (hover over the triangle beside the heading and choose 'add new portal').  Type in the url for your second website.

Repeat, adding the portal for your third site.

The host login is the same for each site.  The admin login will be 'admin' by default on the first site and will be whatever you've set up on the other sites.  Make sure to change the admin password on the first site too.

Then away you go.  hth.
/Brian C
 
New Post
5/5/2006 5:35 PM
 
Jay Mann

Joined: 5/1/2006
Posts: 9

Do you mean one installation of DotNetNuke will work for multiple websites?

Because I already have DNN install and using it for my first website.  I have 2 other sites on the wh4l hosting account that needs to run DNN also.  Do you mean I don't need another set of tables on the database for the second site?

Thanks.

 
 
New Post
5/5/2006 8:08 PM
 
Brian C



Joined: 2/8/2006
Posts: 92
That's exactly what I'm saying. 

If you have your first site, just log in as host, add host > portals, etc (as above).

Always nice to discover that something is easier than you thought.
/Brian C
 
New Post
5/6/2006 1:00 AM
 
Jay Mann

Joined: 5/1/2006
Posts: 9
If I set it up like you suggested, will I have trouble in the future if I want to move 1 of the website to another hosting company? Will I have to copy the whole database to the new host? Wouldn't that mean moving the data for all three sites?

Thanks for the help again.
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How do I use 1 database for multiple DNN instal?How do I use 1 database for multiple DNN instal?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out