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: Importing Settings  (Read 4474 times)

0 Members and 1 Guest are viewing this topic.

nowordneeded

  • Coppermine frequent poster
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 224
Importing Settings
« on: March 26, 2013, 05:57:56 am »

This really is a question for all my galleries, but for the sake of this post I'll mention this one: http://mitchpileggi.org/gallery. I'm running the current stable version of 1.5.20. So, I use the same settings on all my galleries an it's getting to be a pain in the 'you know where' to have to run through the config page an have to remember what the settings are each time. So my question is this: Is it possible to import the settings from a previous gallery to another in order to not have to keep going through the same process again and again and again?

Thanks in advance.

NWN
Logged
Sometimes my musings are too confusing for someone not inside my head.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Importing Settings
« Reply #1 on: March 26, 2013, 01:40:49 pm »

There's no import/export option, but you can easily restore a dump of your config table to your other galleries.
Logged

nowordneeded

  • Coppermine frequent poster
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 224
Re: Importing Settings
« Reply #2 on: March 26, 2013, 07:52:40 pm »

So what would I do then, import the config from mysql and use upload it to my other databases?
Logged
Sometimes my musings are too confusing for someone not inside my head.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Importing Settings
« Reply #3 on: March 26, 2013, 08:16:38 pm »

Create a dump of your "source" config table (export). Restore that dump to your "target" galleries' MySQL databases while overwriting the existing table (import). I personally use MySQLDumper to create dumps and to restore them. Of course you can also use PHPMyAdmin, any similar tool or a command line tool of your choice to do that.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4886
    • Windsurf.me
Re: Importing Settings
« Reply #4 on: March 26, 2013, 09:03:08 pm »

Please remember to backup all your databases before starting ;)
Logged
It is a mistake to think you can solve any major problems just with potatoes.

nowordneeded

  • Coppermine frequent poster
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 224
Re: Importing Settings
« Reply #5 on: March 29, 2013, 04:36:54 am »

Hi there. I have done what you've told me here, but I keep getting an error in the target gallery. For some reason I just cannot get the target gallery to import from the file export from the other database.

The target gallery is: http://joncypher.samskara.org/gallery and it is running the latest stable version of 1.5.20.
Logged
Sometimes my musings are too confusing for someone not inside my head.

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4886
    • Windsurf.me
Re: Importing Settings
« Reply #6 on: March 29, 2013, 09:44:14 am »

What error are you getting? I am guessing it is a table already exists error? If that is the case you need to first drop the table on your target database.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

nowordneeded

  • Coppermine frequent poster
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 224
Re: Importing Settings
« Reply #7 on: March 29, 2013, 09:50:00 am »

Here is the error:

Error

SQL query:

-- -- Dumping data for table `cpg15x_albums` -- INSERT INTO `cpg15x_albums` (`aid`, `title`, `description`, `visibility`, `uploads`, `comments`, `votes`, `pos`, `category`, `owner`, `thumb`, `keyword`, `alb_password`, `alb_password_hint`, `moderator_group`, `alb_hits`) VALUES
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
Logged
Sometimes my musings are too confusing for someone not inside my head.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Importing Settings
« Reply #8 on: April 09, 2013, 12:13:06 pm »

Don't restore all tables, but just the config table (in your gallery cpg15x_config).
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.