multiple sql databases for multi installs?

pilotchip

If I wanted multiple installations of zenphoto under one directory (for ie: gallery/zeninstall1 and gallery/zeninstall2) do i need 2 different mySql databases? one database for each install? It seems funky things were happening when i had 2 galleries feeding off of the same database path.

thanks for the help.
jason

trisweb

No, it's in the config file. Set a different "mysql_prefix" for each install and you can use the same database.

pilotchip

ok maybe i figured it out.

the database names and passwords are all the same for each install of zenphoto on my server. all i do is add a prefix ie, pets and rerun setup. i didn't know about running setup again.

is this correct?

Chilifrei64

I have run a re-setup after changing the information in the config.php and had no problems.. I am also running about 10 photo albums on one SQL Database with no problems.

barnster

Hi, I'm sorry I have to resurface this topic, but couldn't find anything else like it.

OK, so my website is: barnster.net
I'm in need of two separate galleries, one under "Photos" and the other under "Designs"

Currently, I have zenphoto set up under Designs, and I'm using a plugin for Photos, but one of the best things about ZenPhoto is its ftp seamless upload and editing abilities.

So if I understood the above correctly...
Do I need to install zenphoto twice? so zenphoto1 and zenphoto2 would be under my main root folder?

And could someone clarify what I have to do to get it to work properly? With the databases?

Thanks!

sbillard

To have two separate galleries you will need to install Zenphoto twice. You can run these two installations with either one or two databases. To run with one database, the `$conf['mysql_prefix'] = "zenp_";` lines in the two zp-config.php files must be set to different values. To run with two databases you would set each zp-config.php file's `$conf['mysql_database'] = "xxxxx";` to the appropriate database name.