Multiple Galleries - 1 MySql Database?

[sciboy]

Hi there - I was wondering if it's possible to host multiple coppermine photo galleries from a single MySQL database. I have plenty of room in the database i am using, but don't want to mess it up by trying to start another photo gallery (for a different site, but hosted on the same server) with the same database - so any insight would be EXTREMELY helpful!

Than, Joshua

[kegobeer]

Sure you can.  Just give each Coppermine install a different table prefix.

[sciboy]

i must be stupid - the first gallery i put up didn't have a table prefix - does that mean its in a parent directory or something?

i'm not sure how to make a table prefix

Joshua

[Abbas Ali]

Table prefix is the prefix given to table names in database. For example if in database there is a table cpg133_albums, then prefix for your current installation is cpg133_ . This has nothing to do with directory.

When installing the second cpg, on insallation page it will ask for table prefix. Give any prefix you like other then the current prefix (which in above example is cpg133_).