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
yes.. that is the database prefix
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.
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.
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.