forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: akulion on October 24, 2006, 07:01:59 pm

Title: Moving galery from one domain to another [help req]
Post by: akulion on October 24, 2006, 07:01:59 pm
Hi,

I wanted to ask what I need to do to move my entire coppermine instalation from one domain to another?

Where all would I need to make changes so that I have minimal impact because of the move?

Btw I did a search before askin - only came up with 1 topic, which was about moving hosts.

Also on a side note:

What do I need to do to install 2 coppermine galleries in the same database? Would I use different table prefixes perhaps?

thanks

aku
Title: Re: Moving galery from one domain to another [help req]
Post by: johndankey on October 25, 2006, 08:53:30 pm
Aku,

I did that not long ago.  All that I needed to do was to copy the db over using PHPAdmin, change the domain on the config page & run the update located in the admin page.  As I recall, the table prefix is set when you run the install, so yes, to install 2 or more galleries in one db, all you need to do is change the prefix.

JD
Title: Re: Moving galery from one domain to another [help req]
Post by: Joachim Müller on October 25, 2006, 09:02:28 pm
Has been asked and answered quite often, please use the search (http://forum.coppermine-gallery.net/index.php?action=search2;search=move%20server).
Title: Re: Moving galery from one domain to another [help req]
Post by: akulion on October 26, 2006, 05:51:08 pm
Aku,

I did that not long ago.  All that I needed to do was to copy the db over using PHPAdmin, change the domain on the config page & run the update located in the admin page.  As I recall, the table prefix is set when you run the install, so yes, to install 2 or more galleries in one db, all you need to do is change the prefix.

JD

thanks  ;D

gau i did use search but i couldnt find the answer for the domain bit so i asked  :)
Title: Re: Moving galery from one domain to another [help req]
Post by: Joachim Müller on October 26, 2006, 07:15:15 pm
Issue solved then?
Title: Re: Moving galery from one domain to another [help req]
Post by: Iced Coffee on January 03, 2007, 04:32:29 am
Aku,

I did that not long ago.  All that I needed to do was to copy the db over using PHPAdmin, change the domain on the config page & run the update located in the admin page.  As I recall, the table prefix is set when you run the install, so yes, to install 2 or more galleries in one db, all you need to do is change the prefix.

JD

I did it, but I don't know why I only see this warning when I try to enter my cpg at the new domain:
Fatal error :

I see nothing else but that. Please help !!!
Title: Re: Moving galery from one domain to another [help req]
Post by: Nibbler on January 03, 2007, 04:21:05 pm
http://coppermine-gallery.net/tutorial/debug_mode.php
Title: Re: Moving galery from one domain to another [help req]
Post by: Iced Coffee on January 11, 2007, 05:23:42 am
http://coppermine-gallery.net/tutorial/debug_mode.php

Thanks Nibbler, I can see the error now:

Quote
Fatal error:

While executing query "select * from cpg148_plugins order by priority asc;" on 0

mySQL error: Table 'hpgiadinh_novbb.cpg148_plugins' doesn't exist

Could you pls help how to correct this?

Thanks.
Title: Re: Moving galery from one domain to another [help req]
Post by: Joachim Müller on January 11, 2007, 08:50:15 am
The error message complains about the table missing, so you appear not to have restored the full dump from your old server. Create the table manually by running the following query in phpMyAdmin:
Code: [Select]
CREATE TABLE cpg148_plugins (
  plugin_id int(10) unsigned NOT NULL auto_increment,
  name varchar(64) NOT NULL default '',
  path varchar(128) NOT NULL default '',
  priority int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (plugin_id),
  UNIQUE KEY name (name),
  UNIQUE KEY path (path)
) TYPE=MyISAM COMMENT='Stores the plugins';
Alternatively, you could run the update.php script. Make sure that your mySQL user has got the privilege to create a table.
Title: Re: Moving galery from one domain to another [help req]
Post by: Iced Coffee on January 16, 2007, 12:57:14 am
Thanks GauGau, my problem is solved.