+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: multiple sql databases for multi installs? (/thread-172.html)
multiple sql databases for multi installs? - pilotchip - 2005-12-14
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
multiple sql databases for multi installs? - trisweb - 2005-12-15
No, it's in the config file. Set a different "mysql_prefix" for each install and you can use the same database.
multiple sql databases for multi installs? - pilotchip - 2005-12-18
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?
multiple sql databases for multi installs? - Chilifrei64 - 2005-12-19
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.
multiple sql databases for multi installs? - barnster - 2007-09-04
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!
multiple sql databases for multi installs? - sbillard - 2007-09-04
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.