help with installation information...

janetg

hi there...

i'm having trouble getting this installed, so i would like some confirmation that i am doing things correctly..

i create a database on my server...give it a user name/pw
use that information in the config.php file -
HOWEVER, - database prefix? what is that?

now on the server that i'm using (lunarpages) - they require the base name, ie, "jsgrey_" before database names and such when using other programs similar. is this the datbasebase prefix?

thanks

Chilifrei64

yes.. that is the database prefix

peh

The prefix is used to name your database tables.... most to avoid problems with tables with identical names.

So for Zenphoto you could use prefix ie. "zp15_" so if you would install say 2 instances of Zenphoto, the prefix in the second install should be like "zp16_"....

If you use a database that only is for Zenphoto and nothing else, then you dont need a prefix.

Personally I have lots of scripts using the same database, so all uses a prefix to avoid table-name mixing :-)

Paul.

peh

I think "jsgrey_" is the first part of the database name... I'm also on Lunarpages and they use the account name ie. "jsgrey" as first part of the database name.

The prefix you can specify when installing ZP is your free choice, and is used for naming the tables inside the database, but it's a good idea to choose a prefix that indicates what the tables are used for, if you ever need to look into
the database.

janetg

thanks - i've been having a devil of a time getting this installed...

i hope you guys stick around if i need anything further...i actually got the setup page this time = but am now getting failed to open db errors...so back i go..

janetg

wcroth55

You MUST use a database prefix, even if you have created a dedicated MySQL database for Zenphoto.

I found out the hard way, by leaving in the default prefix of ".". Turns out MySQL *hates* table names that start with "." -- in particular it completely screws up MySQL master/slave replication.

MarkRH

Not sure why you posted on a 9 year old thread. Anyway, I don't use a database prefix for the tables since it's in its own database. I made it blank. Gallery works fine.