coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: Concorde Rules on December 09, 2006, 06:17:25 PM

Title: Moving picture directories
Post by: Concorde Rules on December 09, 2006, 06:17:25 PM
right, I run www.concorde-photos.co.uk.

The G-BBDG section has been going in one folder, so 2004, 2005 and 2006 photos are all in one folder, making it dam hard to find adding new folders.

I want to move the folders into another folders with the respective year, so 2005 photo folders go into a 2005 folder.

Using this link:
http://forum.coppermine-gallery.net/index.php?topic=32477.0

I see I have to use PHP My admin, I've basically familar with it.

Now its says this:

UPDATE cpg_pictures SET filepath = '/new/file/path/' WHERE filepath = '/old/file/path/';


Im not *quite* sure how it should be.


Lets say I want to move the 2nddecember2006 folder to 2006.

Would it be:
UPDATE cpg_pictures SET filepath = '/albums/concorde/202_bbdg/2006/2nddecember2006' WHERE filepath = '/albums/concorde/202_bbdg/2nddecember2006';



Would this be run in: Run SQL query/queries on database (Main one or cpg_pictures?)

Cheers :)

Title: Re: Moving picture directories
Post by: Concorde Rules on December 09, 2006, 06:33:00 PM
ahaha, lol! dont it myself.

Easy that :)

Just takes a while..

Gotta update the site while im at it, new updates every week it seems ;)