Database

desabol

Hi all,

I am moving from Gallery2 / WPG2 over to ZenPhoto simply because I agree with your philosophy that simple is better and doesn't mean inferior.

I am getting ready to install everything alongside of my WP installation. I did have a question regarding the ZenPhoto database. Would it be better to set up a stand alone DB for ZenPhoto or would it be ok to use my existing WP DB?

I am trying to keep everything simple and together, but don't want to do something that could end up hurting me in the long run.

thinkdreams

Desabol-

It is much better in my opinion to set up separate databases. If you are restricted by your webhost on the amount of DBs that would be the only reason I would see to do it that way. I have been running separate DBs for months now and have had no trouble.

Running separate DBs gives you the flexibility to upgrade or change your DBs in either wordpress or zenphoto without modifying the other "shared" prefixes in your DBs, and you don't have to mess with prefixes either.

Chilifrei64

I too recommend separate databases, however.. I am using zenphoto both ways and I haven't had any problems with either..

desabol

Thanks to both of you for your quick response. What you are saying makes sense, and since I have no limitations on my DB's, it sounds like a great idea to keep the DB's separate!

Again, thank you!

trisweb

There's no difference. Use a prefix if you put them in the same DB.

For organizational or management purposes, it's nice to have them separate. Just a matter of preference.

jimstr

Hi! I am yet another newbie so thanks in advance for any help users will provide.

First time user ever - I configured the zp-config.php hopefully to the best of my knowledge (the only other experience I have is from a long time ago when I first configured eggdrop bots - not the best reference but still I wasn't new to config files) and general html/internet experience. Now everything has been uploaded to my shared server on my service provider's server (mediatemple.com).

I am wondering how to manage the database. First time I went to myurl.com/zen/setup.php and I get this error message:

MySQL Error: Could not connect to the database server.

So before entering my admin information and going on with the rest of the installation/setup I want to fix this.

Should I simply create one by changing its name in the zp-config.php?
here's my setting right now (it is unchanged)

$conf['mysql_database'] = "database_name";
$conf['mysql_prefix'] = "";

thanks again for any help.
Cheers - jerome

jimstr

I found an answer on another thread!

http://www.zenphoto.org/support/topic.php?id=276&replies=7

thanks