1 mysql db 2 EE on 2 different subdomains

[tommykjensen]

On my new host I only have one mysql db (can buy more..).

I want to have a main EE that display my regular photos.

On a different subdomain I want only one exhibit with photos from a special event.


Obviously I could edit all the scripts and find all references to table names and change the prefix from ee_ to ee2_ and create a new set of tables that way.

But for obvious reasons I don't want to do that so what are my options to accomplish above?

[MMCM]

A simple solution could be to set a password for the special event, if you don't need different welcome text and different news. If you use the same password on multiple galleries, you can navigate within those galleries.

[tommykjensen]

That could work if it wasn't for the fact that all should be public. Setting a password would prevent users just surfing by to see the photos.

[MMCM]

How do visitors find your website? Usually they follow a link, where you can include the password. Otherwise you could set up a redirecor page to your password protected galleries, or include a redirect statment somewhere in .htaccess. On my site, I customized the header to include two links to my own and the galleries of my wife, both with different passwords, to separate them from the public galleries.

[neil_r]

It's not very elegant but you could include the password in the URL

[ArtM]

On my new host I only have one mysql db (can buy more..).

I want to have a main EE that display my regular photos.

On a different subdomain I want only one exhibit with photos from a special event.


Obviously I could edit all the scripts and find all references to table names and change the prefix from ee_ to ee2_ and create a new set of tables that way.

But for obvious reasons I don't want to do that so what are my options to accomplish above?
How about having TWO copies of EE in seperate directories, each accessed by a different subdomain. Install each pointing to a DIFFERENT MySQL DataBase Name - but the same MySQL installation. I have this setup & it works fine.

- ArtM

[tommykjensen]

How about having TWO copies of EE in seperate directories, each accessed by a different subdomain. Install each pointing to a DIFFERENT MySQL DataBase Name - but the same MySQL installation. I have this setup & it works fine.


The problem with that is I only have one database which means all tables for both engines have to be in the same one. And to accomplish that I would have to edit all the code so all tables for the second engine is prefixed with f.ex. ec2 so the tables won't conflict.

[tommykjensen]

Thanks for the suggestions.

To be honest I don't like the password idea, it will work sure but I just don't like to "password protect" a gallery that need to be public.

Instead I will do this. I will just install one EE on the main site which will have all the galleries. On the subsite I will redirect the user to the specific gallery in the mainsite.