rename albums folder?

[Colliope]

I've been creating folders (/cpg143/albums/foldername) to upload pics to and
then using Batch Add to add the pics to my Gallery.

I occassionally rename Albums in the Gallery. Is it ok to rename the actual folder
that they're located in as well to keep them matched-up?

C

[Nibbler]

Yeah, but you'll need to update the database (pictures table, filepath field) manually.

[Colliope]

Yeah, but you'll need to update the database (pictures table, filepath field) manually.

If it's simply changing a path name somewhere, I can do that. But where do I do it? From phpMyAdmin or from somewhere in Coppermine itself?

Thanks,
C

[Nibbler]

phpmyadmin, hence 'manually'. If you search the board you will find previous posts about this, but you need to run a query like

Code Select Expand

UPDATE cpg_pictures SET filepath = 'newpath' WHERE filepath = 'oldpath'

If you are not familiar with phpmyadmin make a backup of the table first.

[Colliope]

Thanks.

[Colliope]

Sorry for the time delay, lost the time to tackle this 'til now.
Anyway, I have looked around phpMyAdmin and feel comfortable manually typing in new path names. However, I don't see any button/option labeled "backup database" or whatnot. Can you instruct me on how to make a backup before I proceed?
Thankyou,
C

[Nibbler]

It's called 'Export'. Try searching the web if you need a tutorial.

[Joachim Müller]

Unrelated reply to this thread split into separate thread. Locking this one.