Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Multiple Galleries - 1 MySql Database?  (Read 3091 times)

0 Members and 1 Guest are viewing this topic.

sciboy

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Multiple Galleries - 1 MySql Database?
« 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
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Multiple Galleries - 1 MySql Database?
« Reply #1 on: January 07, 2006, 04:14:44 am »

Sure you can.  Just give each Coppermine install a different table prefix.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

sciboy

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Multiple Galleries - 1 MySql Database?
« Reply #2 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
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: Multiple Galleries - 1 MySql Database?
« Reply #3 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_).
Logged
Chief Geek at Ranium Systems
Pages: [1]   Go Up
 

Page created in 0.109 seconds with 20 queries.