coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: ahbsv on September 19, 2005, 03:51:04 PM

Title: 2 domain 1 mySQL database
Post by: ahbsv 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
Title: Re: 2 domain 1 mySQL database
Post by: artistsinhawaii on September 21, 2005, 06:47:58 AM
Davide,

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

Dennis
Title: Re: 2 domain 1 mySQL database
Post by: ahbsv 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






Title: Re: 2 domain 1 mySQL database
Post by: Stramm 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";
Title: Re: 2 domain 1 mySQL database
Post by: ahbsv 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
Title: Re: 2 domain 1 mySQL database
Post by: Joachim Müller 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?
Title: Re: 2 domain 1 mySQL database
Post by: ahbsv 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
Title: Re: 2 domain 1 mySQL database
Post by: Stramm 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
Title: Re: 2 domain 1 mySQL database
Post by: Joachim Müller 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.
Title: Re: 2 domain 1 mySQL database
Post by: ahbsv 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
Title: Re: 2 domain 1 mySQL database
Post by: Tranz 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.
Title: Re: 2 domain 1 mySQL database
Post by: ahbsv on September 21, 2005, 04:01:14 PM
I need only that mysql database remain intact and no corrupted by other site.

backup .. first!  ;)