forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: sciboy on January 07, 2006, 03:55:06 am

Title: Multiple Galleries - 1 MySql Database?
Post by: sciboy on January 07, 2006, 03:55:06 am

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

Title: Re: Multiple Galleries - 1 MySql Database?
Post by: kegobeer on January 07, 2006, 04:14:44 am

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

Title: Re: Multiple Galleries - 1 MySql Database?
Post by: sciboy on January 07, 2006, 06:50:50 am

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

Title: Re: Multiple Galleries - 1 MySql Database?
Post by: Abbas Ali on January 07, 2006, 07:21:59 am

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_).