By quacklin on

hello,

I have been trying drupal on a verio freeBSD VPS in the last month and I like it very much.

Now I have a new debian virtualserver, and I would like to move my current projects on this new virtualserver. (Currently this porject are in ASP on a old propietary CMS, a real mess though http://www.mountnet.net )

My question is:

I have to create 3 websites portal. They have to be in english and in italian. Sometimes they have news to share, some news are not to be shared. What it will be the best way to proceed?

I thought to install drupal three times, on different subdirectories for each virtualhost, and associate to three different database. In this way I think I will have to publish the same news three times, and this is not good. if i 'm not mistaken, I will also have to install drupal another thrre times to manage the two languages, since news and contect will be created in the relevant language)

Am I completely wrong or is this the best way to proceed?

Thank you for your comments,

Quacklin

Comments

denisr’s picture

denisr commented

what you can do is install drupal 3 times, using a single database with 3 different table prefix. playing around with the table prefix you can share some tables between the sites.

ie. you can use an only user table for all the sites and have an unique login for everything. I believe you can use the same concept for the news.

look in drupal handbook for more information!

quacklin’s picture

quacklin commented

thank you for your reply.

I thought that was possible, thank you

To select from the Mysql DB , do I have to modify the PHP code or is just something I can configure in administration?

In other words, is it possible to share categories or section within different drupal installations but in the same server DB without modify the PHP code?

Sorry if this question is already in the book....;-)

Thank you

quacklin

axel’s picture

axel commented

You don't need modify PHP code, only setup properly configuration files for either site (though from other side config file in PHP and it may seem as code modification :) Site config stored in includes/conf.php (see comments in it).

You may ever place drupal files in one directory, setup three virtual hosts and setup three configs for either host - Drupal allow such thing (configs named as you hosts then, instead of default conf.php). And see http://drupal.org/node/2622 for table prefix setup.

--
Axel,
Russian Drupal Community

quacklin’s picture

quacklin commented

thank you Axel,

I will start with one, add prefix, and see the amount of content to be shared.

hope to post my site in drupal new entries soon ;-)

thanks again

Quacklin