[Closed]: Move pictures to another album and change album name

[hl90]

Hi, how can i move picture(s) from an album to another album. And how can I change the album name?

For example:

photoshoots/2008/marc/001.jpg
move to:
photoshoots/2008/black/001.jpg

and
photoshoot/2008/marc
change to:
photoshoots/2008/black

I don't want to do this in coppermine it self but in PhpMyAdmin. I already searched for more info on this forum but I didn't really understand.
I know I have to run a query but I'm not sure where to do that. Can someone help me?

[phill104]

Try this thread.

http://forum.coppermine-gallery.net/index.php/topic,45737.0.html

[hl90]

Where do I have to run the UPDATE cpg_pictures SET aid = <newaid> WHERE aid = <oldaid>?
Sorry I don't really get it.

[phill104]

You run it in something like phpmyadmin but your host may provide a dfferent tool for manipulating your database.

Here is a good tutorial.

http://community.mybboard.net/showthread.php?tid=4720

Make sure you backup your database before fiddling with it.

[hl90]

Thanks for the tutorial but to be honest it didn't really help because it's for a forum and not for coppermine gallery.
Let's say if I want to change an album name, where should I click first at MyPhpAdmin at the left menu? cpg14x_albums
or cpg14x_pictures. For an example if I want to change the albumname "black" into "white" how should to fill in this at SQL:

UPDATE cpg_pictures SET aid = <newaid> WHERE aid = <oldaid>

[phill104]

That tutorial just shows how to use phpmyadmin. It doesn't matter what package you are editing, it just shows you how to enter a query.

We are not here to teach you how to use phpmyadmin. You need to learn that. It is very easy and the tables are quite self explanatory.

If you just need to rename an album or move a few files then I suggest you do that from within coppermine.

[hl90]

nevermind then....not very helpfull...

[Joachim Müller]

What a nice attitude...