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: 2 domain 1 mySQL database  (Read 6551 times)

0 Members and 1 Guest are viewing this topic.

ahbsv

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
    • DestinazioneUSA
2 domain 1 mySQL database
« on: September 19, 2005, 03:51:04 pm »

I've a standalone coppermine gallery in my site. Is possible clone it in a new site?

www.domain1.com    with galleryABC
www.domain2.com    with galleryABC

I transfer into the new site the gallery and the photo ... and then?

Thanks a lot!

Davide

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: 2 domain 1 mySQL database
« Reply #1 on: September 21, 2005, 06:47:58 am »

Davide,

Are you changing servers are you just cloning coppermine on the same server?

Dennis
Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.

ahbsv

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
    • DestinazioneUSA
Re: 2 domain 1 mySQL database
« Reply #2 on: September 21, 2005, 08:23:15 am »

I have 2 different sites and I want to share the same configuration and mysql database.

They are on different servers

site1:   www.site1.com
site2:   www.site2.com

On site1 the gallery is working. I want the SAME gallery in site2. I have transfered all images and thumbnails in site2, is possible modifying only the config files share the mysql database?

Thanks






Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: 2 domain 1 mySQL database
« Reply #3 on: September 21, 2005, 08:32:29 am »

try something like this to create a mysql user (on the box with the mysql server of course), the IP is the IP of the remote machine. On that box you modify config.inc.php to
$CONFIG['dbserver'] = 'IP';       
$CONFIG['dbuser'] =  'USERNAME';
$CONFIG['dbpass'] = 'PASSWORD';

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

ahbsv

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
    • DestinazioneUSA
Re: 2 domain 1 mySQL database
« Reply #4 on: September 21, 2005, 08:45:48 am »

ok. but fortunately the gallery is "closed", no new pics or user. I need only to clone it into my new site

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: 2 domain 1 mySQL database
« Reply #5 on: September 21, 2005, 08:51:00 am »

@Stramm: I think that ahbsv is asking for something else - your advice may need a higher skill level...

@ahbsv: are you actually asking: "how can I move my coppermine install from site "A" to site "B" without losing anything?
Logged

ahbsv

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
    • DestinazioneUSA
Re: 2 domain 1 mySQL database
« Reply #6 on: September 21, 2005, 09:40:51 am »

No, I want to COPY the gallery. I want the SAME gallery into different sites!

I know that I must copy the images and the thumbmail but I want only ONE MySql Database, I don't want reinstall the gallery!

Davide

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: 2 domain 1 mySQL database
« Reply #7 on: September 21, 2005, 09:51:48 am »

then as mentioned above
you may also want to search the web for 'mysql remote connection' to get more info

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: 2 domain 1 mySQL database
« Reply #8 on: September 21, 2005, 09:55:12 am »

then just upload the coppermine files to the second (clone) gallery and edit include/config.inc.php - edit the mysql data there: you can't use "localhost", but you will have to specify the domain name (or IP address) of the mysql server. Generally speaking: you don't have to do much at all, but your webhost (the one where your mysql database resides) has to allow access from remote servers (most webhosts don't allow that). Bottom line: you may have to ask your webhost if he actually allows what you're up to.
Logged

ahbsv

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
    • DestinazioneUSA
Re: 2 domain 1 mySQL database
« Reply #9 on: September 21, 2005, 10:04:55 am »

Mysql database is yet in another ip/domain about the site1, so I think there is no problem edit include/config.inc.php !

Thanks a lot

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: 2 domain 1 mySQL database
« Reply #10 on: September 21, 2005, 03:41:32 pm »

There would be a minor complication since the ecard URL would be incorrect for one of the galleries. This would affect some functionalities.
Logged

ahbsv

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
    • DestinazioneUSA
Re: 2 domain 1 mySQL database
« Reply #11 on: September 21, 2005, 04:01:14 pm »

I need only that mysql database remain intact and no corrupted by other site.

backup .. first!  ;)
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.