Page 1 of 1

[how to] use phplist with two sites on the same server

PostPosted: 11:53pm, Thu 22 Feb, 2007
by briandunning
I want to use this on two different sites on the same server. Preferably sharing the same database. But all different domains, different subscribe pages, etc. Is this possible?

PostPosted: 7:04pm, Fri 23 Feb, 2007
by Dragonrider
Yes!

Install the two versions of phplist into two different subfolders, eg: www.yourfirstsite.com/lists and www.yourothersite.com/lists and when you come to install them, set the database access as normal, but change the phplist prefix, for the database, to something specific to each site.

PostPosted: 7:10pm, Fri 23 Feb, 2007
by briandunning
So, two separate databases then?

PostPosted: 8:34pm, Fri 23 Feb, 2007
by Dragonrider
briandunning wrote:So, two separate databases then?


That depends on how you define a database.

If you need to use two seperate MySQL databases, then not necessarily, though you can.

If you want to offer two different LISTS, or Newsletters or whatever you want to call them, then use one database, but set up two lists within one installation of phpList.

If you want to use phpList over two different sites, then you can use one MySQL database, but using different prefixes in the installation process.

Does that help?

PostPosted: 9:00pm, Fri 23 Feb, 2007
by briandunning
I see what you mean. Basically it's got to be separate sets of tables if it needs to run on two different domains.

PostPosted: 9:07pm, Fri 23 Feb, 2007
by Dragonrider
briandunning wrote:I see what you mean. Basically it's got to be separate sets of tables if it needs to run on two different domains.

Yes, because otherwise, apart from being downright confusing running two lists for two sites, on the same installation of phplist, you're going to have to rewrite the from email, the domain, the sender, the headers etc each time to send an email from the other site....

I have two installations of phpList running on my webspace. One for my Gardeners' site and this uses my gardeners MySQL database, and the other for a Musical Festival website which uses the festivals' MySQL database.

I did start off by having a lists MySQL database as well (think I get 20 with my webspace package) and simply used different database prefixes for the two phplist installations.

After a while, I decided to move the data into the actual databases and also the installations to within the revelant folders and subfolders, but that's another story!

PostPosted: 9:12pm, Fri 23 Feb, 2007
by briandunning
Rock, thanks a lot. :)