Easy way to move albums from one category to another

[lolainslacks]

When I started off my gallery I sorted events pics by categories like Awards & Galas, Movie Premieres & Screenings, Film Festivals, etc.. But now I want to sort the albums by year. How do I move the albums from these categories to the years ones?

Is there an easy way to do that without losing the viewings count? Maybe via phpMyAdmin?

Help, please!

Thanks in advance!

[lurkalot]

See, http://documentation.coppermine-gallery.net/en/albums.htm#album_howMoveAlbum

All comments, views, votes etc will move with them.  If you're not sure, just create a test album, and try moving it around, and you see how it works

[lolainslacks]

See, http://documentation.coppermine-gallery.net/en/albums.htm#album_howMoveAlbum

All comments, views, votes etc will move with them.  If you're not sure, just create a test album, and try moving it around, and you see how it works

I have over 150 albums. Is there any way of batch doing it?

[Αndré]

There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.

[lolainslacks]

There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.

Do I have to change anything in the pictures table?

[Αndré]

No.

[lolainslacks]

There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.

What do you mean by adjust the category values?

[Αndré]

Just look at the albums table. There's a column with the categories' IDs in it, which determine which album belongs to which category. If you adjust that value (for each album), it/they will appear in the corresponding category.