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: Migrating Coppermine Gallery to another server  (Read 4769 times)

0 Members and 1 Guest are viewing this topic.

pols1337

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 244
Migrating Coppermine Gallery to another server
« on: April 14, 2013, 02:07:10 am »

Hi,

I need help with moving my Coppermine installation from one host (a shared hosting environment, no Cpanel) to another host (virtual private server, with cPanel).  I can FTP the files over, so all of the pictures and images are the same.  But what do I do about the MySQL databases?  When I export / import from phpMyAdmin, it works ... except when I try to access my gallery, I get the following error:

Coppermine critical error:
Unable to connect to database !

MySQL said: Unknown MySQL server host 'mysql.gip.superb.net' (1)


Where mysql.gip.superb.net is the OLD location for the MySQL server.  I probably need to change it to localhost.  How do I do that on my existing Coppermine database?
Logged

pols1337

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 244
Re: Migrating Coppermine Gallery to another server
« Reply #1 on: April 14, 2013, 02:08:26 am »

Actually I just realized I can probably change the [mysql.gip.superb.net] on the new host, no need to change on the old host and then export.  I just don't know where to look in the database. 

Please advise. 
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Migrating Coppermine Gallery to another server
« Reply #2 on: April 14, 2013, 10:19:27 am »

The file /include/config.inc.php contains all your database details and you can adjust the pointer to your db in there.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Migrating Coppermine Gallery to another server
« Reply #3 on: April 15, 2013, 10:41:38 am »

pols1337, it's all described in the docs:
Edit the database settings
Your new webhost must have provided you with the mySQL access data (you already had to use that data to restore the dump on the new server). That mySQL data usually will differ from the mySQL data on the old webserver, so you will have to edit the file that contains those data. Use a plain text editor (notepad.exe is fine) and edit include/config.inc.php: inside that file, you will find the old mySQL data that you will need to overwrite with the mySQL data for the new server.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.