2 domain 1 mySQL database

[ahbsv]

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]

Davide,

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

Dennis

[ahbsv]

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]

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]

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]

@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?

[ahbsv]

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]

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

[Joachim Müller]

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.

[ahbsv]

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]

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

[ahbsv]

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

backup .. first!