forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: shiftsrl on September 04, 2006, 03:12:00 pm

Title: Moving directory of images
Post by: shiftsrl on September 04, 2006, 03:12:00 pm

Since I've used coppermine for some time, I would like to make some order in my album directory and I would like to move around some folders. If I've this structure, for example

pictures
--trip1
--trip2

and would like to have this one

2002
--trip2

2003
--trip1

apart from moving the filders via FTP, how can I be sure that Coppermine will find the albums once the structure is changed?

Thanks in advance

Title: Re: Moving directory of images
Post by: ralfs on September 04, 2006, 03:38:41 pm

Hi,

The easiest way would be via SQL queries:

Run phpmyadmin, take your database.
Then 'SQL' and enter

Update cpg_pictures
SET filepath = "data/2002/trip2/"
WHERE filepath = "data/pictures/trip2/"

assumed, your directory structure starts underneath albums/data

I had to do that quite often in the last months and it worked fine.

Regards,
Ralf